We have just released version 2.1.0 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 TRUNCATE
• Support Bulk Insert
• Support keep connection control and connection cache information
• Refactored tests

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

Best Regards,
HIROKI Kumagai