We have just released version 2.1.1 of the Foreign Data Wrapper for SQLite. This release can work with PostgreSQL 10, 11, 12, 13 and 14. This release improves following items :
Support Insert/Update with generated column
Support check invalid options
Bug fixings:
Fix issue of accessing fts table on SQLite
Fix memory leak
The FDW supports following key features :
SELECT, INSERT, UPDATE and DELETE of foreign tables
WHERE clauses is push-downed
Aggregate is push-downed
ORDER BY is push-downed
JOIN is push-downed (LEFT,RIGHT,INNER)
LIMIT and OFFSET are push-downed (*when all tables queried are fdw)
Transactions
This is developed by Toshiba Software Engineering & Technology Center. Please see the repository for details. Source repository : https://github.com/pgspider/sqlite_fdw