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

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

SQLite

Go

I have created PR for this #3498.

Navigation Menu