Support for START TRANSACTION

[qwenger]

Hi,

I'm currently trying out pgsqlite and ran into the issue that SQL's START TRANSACTION doesn't seem to be understood by SQLite (START isn't a known keyword). Would it be possible to translate it into e.g. BEGIN TRANSACTION?

Background:

I'm trying to reach a SQLite database from PostgreSQL using pgsqlite and postgres_fdw (yes, I know that there is sqlite_fdw but I wanted to try another approach for a number of reasons). The FDW uses START TRANSACTION internally:

CREATE EXTENSION postgres_fdw;
CREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'myip', port 'myport', dbname 'mydb');
CREATE USER MAPPING FOR myuser SERVER myserver OPTIONS (user 'postgres', password '');
CREATE SCHEMA myschema;
IMPORT FOREIGN SCHEMA mydb FROM SERVER myserver INTO myschema;

-- ERROR:  Query execution failed: SQLite error: near "START": syntax error in START TRANSACTION ISOLATION LEVEL REPEATABLE READ at offset 0
-- CONTEXT:  remote SQL command: START TRANSACTION ISOLATION LEVEL REPEATABLE READ