Update limit pushdown logic to push down the limit if all sort clauses are pushed down

turbot / steampipe-postgres-fdw

The Steampipe foreign data wrapper (FDW) is a zero-ETL product that provides Postgres foreign tables which translate queries into API calls to cloud services and APIs. It's bundled with Steampipe and also available as a set of standalone extensions for use in your own Postgres database.

https://steampipe.io/

Apache License 2.0

70 stars 16 forks source link

Update limit pushdown logic to push down the limit if all sort clauses are pushed down #458

Closed kaidaguerre closed 6 months ago

kaidaguerre commented 6 months ago

currently we do not push down limit if there are ANY sort clauses, regardless of whether they are pushed down