pypika

pypika copied to clipboard

The MSSQL syntax also supports quotes but the usual syntax is the one with the square brackets.

deeprobin

While creating an EMPTY `Array` using the REDSHIFT dialect, the sql statement is `ARRAY['{}']` instead of `ARRAY[]`. Could we add support for Presto's dialect to generate the correct sql for...

mndoping1

How do you add a new column to a table?

2

I'm using postgresql. The sql query should be `ALTER TABLE ... `, but the only place in the code base I see `ALTER TABLE` is in `pypika\dialects.py` for `ClickHouseQueryBuilder`

matiasmorant

Bug in filtering None values

1

When a filter value is None, pypika should generate query as `WHERE name is NULL` instead of `WHERE "name"=NULL`.

ChillarAnand

Added ASOF join for QuestDB, Documentation found here: https://questdb.io/docs/reference/sql/join/

aeshaynes

Use of aliased tables in functions generates incorrect SQL

1

### Problem Using a table as an argument to a function works correctly, until the table is aliased. Consider the following code: ``` products = Table('products').as_('p') test_query = Query.from_(products).select(fn.Count(products)) print(str(test_query))...

davidpurser

I think it would be fairly easy to add support for Lateral subqueries. They are part of the ANSI SQL standard and supported by at least Oracle and Postrgresql. Can...

ajustintrue

`isin` method should not use narrow isinstance for generating criterion

1

This is the code: def isin(self, arg: Union[list, tuple, set, "Term"]) -> "ContainsCriterion": if isinstance(arg, (list, tuple, set)): return ContainsCriterion(self, Tuple(*[self.wrap_constant(value) for value in arg])) return ContainsCriterion(self, arg) You'll notice...

JordanReiter

ALLOW ESCAPE CHARACTER IN LIKE COMPARISONS

1

When giving a "like" criterion, escape character can be specified (see https://docs.microsoft.com/it-it/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver15 )

rgusmero

Fix: Add py.typed to root package

4

I don't believe I need to add this to the pypika.clickhouse package. Works well in vscode and along with mypy.

whardier