PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
DuckDB and Databricks/Spark know a SELECT * EXCEPT(cola, colb) or SELECT * EXCLUDE(cola,colb) Syntax, unfortunately, they use different keywords. It seems other DB Systems support this in a similar way as well. I don't think you can express that with Pypika yet, and it was a great addition to me
Hi there
DuckDB and Databricks/Spark know a
SELECT * EXCEPT(cola, colb)orSELECT * EXCLUDE(cola,colb)Syntax, unfortunately, they use different keywords. It seems other DB Systems support this in a similar way as well. I don't think you can express that with Pypika yet, and it was a great addition to me