We have just released version 2.0.0 of the Foreign Data Wrapper for SQLite.

This release can work with PostgreSQL 9.6, 10, 11, 12 and 13.
This release improves following item :

• Support JOIN pushdown (LEFT,RIGHT,INNER)
• Support direct modification (UPDATE/DELETE)
• Support pushdown nest functions
• Support pushdown scalar operator ANY/ALL (ARRAY)
• Support pushdown ON CONFLICT DO NOTHING
• Refactored tests

Bug fixings :

• Don't push down lower/upper function
• Fix processing for DATE data type
• Do not prepare SQL statement during EXPLAIN

The FDW supports following 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)
• nest functions is push-downed
• LIMIT and OFFSET are push-downed (*when all tables queried are fdw)
• scalar operator ANY/ALL (ARRAY) are push-downed
• ON CONFLICT DO NOTHING is push-downed
• 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,
Mototaka Kanematsu