No stream updates with quoted table name

[marek-dabek]

Background

Since some of my column/table names conflict with SQLite's list of reserved keywords I just started quoting every identifier. That causes all my streams to silently fail.

Example

  @Query('SELECT * FROM "table_name"')
  Stream<List<Data>> listAll();

Expected behavior

Stream event published when whenever rows are modified.

Actual behavior

Stream event is not published whenever table rows are modified.

Cause

After lots of debugging I found the culprit. It's the code that parses the SQL query to extract the table names used.

Possible solutions

1. Fix the parser Regexp to include "quoted_table_names"
2. Allow users to manually pass the list of tables used in the query