SQLite: Add support for WHERE clause on the FTS5 Table Name

[ankitrgadiya]

What do you want to change?

SQLite supports WHERE clause directly over the Table name to query all the columns.

CREATE VIRTUAL TABLE IF NOT EXISTS ft
USING fts5(id, name, content);

SELECT name, snippet(ft, -1, "...", "...", "", 30)
FROM ft
WHERE ft MATCH @query

But SQLC does not work with this Query.

# package gen
query.sql:77:7: column "ft" does not exist

What database engines need to be changed?

SQLite

What programming language backends need to be changed?

Go

[naspeh]

I have created PR for this #3498.