Add FTS5 support to sqlite

[kkyr]

What do you want to change?

Add FTS5 support to sqlite engine.

schema.sql

CREATE TABLE recipes (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
);

CREATE VIRTUAL TABLE recipes_fts USING FTS5 (
    name,
    content='recipes',
    content_rowid='id'
);

-- (triggers omitted)

query.sql

-- name: SearchRecipes :many
SELECT rowid, * FROM recipes_fts
WHERE recipes_fts MATCH ?;

Running sqlc generate on the above input results in the following error:

db/sqlite/query.sql:17:1: relation "recipes_fts" does not exist

What database engines need to be changed?

sqlite

What programming language backends need to be changed?

Go