We have just released version 1.2.1 of the Foreign Data Wrapper for SQLite.
This release can work with PostgreSQL 9.6, 10, 11 and 12. This release improves following item : - Added Limit/Sort pushdown for SQLite - Conversion from SQLite numerical value to PostgreSQL TimeStamp These were implemented by Pablo Ruiz García. Thank you! 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 - 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, Mototaka Kanematsu
