Why there is no force_readonly option for server #69
Description
The sqlite-fdw has option for server
force_readonly as boolean, optional, default false
This option is useful if you need grant user permission to create a foreign tables on the foreign server and revoke user permission to modify any table data on this foreign server. This option with true value can disallow any write operations on foreign server table data through SQLite file readonly access mode. This option driven only by foreign server owner role can not be overwritten by any updatable option value. This is a strong restriction given by PostgreSQL foreign server owner user not to modify data in any foreign server tables. Also see Connection to SQLite database file and access control.
Why there is no this option in duckdb_fdw?
How to setup read-only fdw server for duckdb?