This release includes the following:
Features:
- Add configuration file approach to control the pushdowns. We can now provide the list of operators and functions to be pushed down to the remote server safely.
- Add support for the "import_generated" option in IMPORT FOREIGN SCHEMA to include column's generated expressions in the definitions of foreign tables.
- Add support for the TRUNCATE command to truncate foreign tables.
- Add support for ON CONFLICT DO NOTHING in INSERT. We map it to INSERT IGNORE. (#246)
- Add support for IS [ NOT ] DISTINCT FROM operator. (#251)
Other improvements and Fixes:
- Check the shippability of sort clauses properly by making sure that the sort operator is safe to ship.
- Fix an oversight in assessing pushable ORDER BY clause i.e. don't push when underneath query_pathkeys are not safe to push down.
- Push down the "LIMIT n" clause when OFFSET is NULL.
- Fix unstable ordering in sql/select test. (#254)