Each validation run creates a fresh temporary database, so you can test CREATE TABLE statements and other DDL without conflicts. There are no configurable options.
This is a foreign data wrapper (FDW) to connect PostgreSQL to SQLite database file. This FDW works with PostgreSQL 13, 14, 15, 16, 17 and confirmed with SQLite 3.49.0 ...