We have just released version 1.3.1 of the Foreign Data Wrapper for SQLite.
This release can work with PostgreSQL 9.6, 10, 11, 12 and13.
This release supports following features:
- Support function pushdown in the target list (for PGSpider)
- Support Windows build using Visual Studio project
- Bug fixings
- Fix FETCH ... WITH TIES issue
- Fix sqlite_fdw does not bind the correct numeric value when it is
sub-query
The FDW supports following features :
- SELECT, INSERT, UPDATE and DELETE of foreign tables
- WHERE clauses is pushed down
- Aggregate is pushed down
- Order By is pushed down
- Limit and Offset are pushed down (*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
