pypika
pypika copied to clipboard
kayak
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 us...
Hey, I am making `UNION ALL` statement between query result and an aggregate table. However, I am getting exception `pypika.utils.SetOperationException: Queries must have an equal number of select statements in...
Hi, it would be nice to support BigQuery as a dialect. Most features of BigQuery are standard SQL, however there are some difference, specifically when using array\struct fields. For example...
~~ # What I propose that `notnull()` should use `IS NOT NULL`. If the maintainers agree with this change then I'd be happy to submit a PR. # Why As...
In MSSQLQuery, datetime objects get serialized with microsecond precision: ```python >>> pypika.MSSQLQuery.into('foo').columns('a').insert(datetime.now()) INSERT INTO "foo" ("a") VALUES ('2021-11-12T16:04:29.104453') ``` However, the database is not able to convert this string to...
The result from passing a list of lists to insert() is incorrect and differs from passing lists as positional arguments: ```python >>> pypika.MSSQLQuery.into('foo').columns(['a', 'b', 'c']).insert([(1,2,3), (4,5,6)]).get_sql() 'INSERT INTO "foo" ("a","b","c")...
The values "true" and "false" are not recognized and causes an "Invalid column name 'true/false'" error: ```python >>> pypika.MSSQLQuery.into('foo').columns('a').insert(False) INSERT INTO "foo" ("a") VALUES (false) ``` ``` Msg 207, Level...
Support the SQL [CHECK constraint](https://www.w3schools.com/SQL/sql_check.asp) Most [SQL Constraints](https://www.w3schools.com/sql/sql_constraints.asp) are currently supported such as - NOT NULL - UNIQUE - PRIMARY KEY - FOREIGN KEY - DEFAULT But the CHECK constraint...
Due to requiring the FINAL Keyword in Clickhouse i decided to implement it. Implemented: * FINAL Keyword for the Clickhouse dialect. * Added a Constructor to the ClickhouseQuery Builder Class...
Currently there is no possibility to specify subqueries in limit clause. I've encountered this issue while trying to make query with limit specified in percentage. For this i needed to...
Hi, Is there a way to accomplish `percentile_cont(fraction) WITHIN GROUP (ORDER BY sort_expression)`? https://www.postgresql.org/docs/9.4/functions-aggregate.html
