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...
This pull request is intended to revised existing type hint in this project and fix all problems about typing reported by [mypy](https://mypy.readthedocs.io). Including fixes: - `__eq__()` and `__ne__()` accept any...
``` $ tox -av ... default environments: py36 -> testing against python3.6 py37 -> testing against python3.7 py38 -> testing against python3.8 py39 -> testing against python3.9 pypy3 -> testing...
How can I create a Postgres array ordered by some criteria? Sort like: ```sql SELECT ARRAY_AGG(date ORDER BY date DESC) "dates" FROM ... ``` I know `ARRAY_AGG` is not supported...
I have dataclass for query filters like this ``` class Filters: table: str column: str value: List[str] operation: Operator ``` when i want load data from diffrent tables from DB...
Right now you are only able to do .like() for 'LIKE'. However there is no way to add 'LIKE ANY' and it seems like in [enums.py](https://github.com/kayak/pypika/blob/2e33a57d549a9c094f0707f51dd2315bf1d428ae/pypika/enums.py) it would be pretty...
``` table_name = 'test' something = [Cast("a",'VARCHAR'),'b','c'] x = Query\ ._builder(as_keyword=True)\ .from_(table_name)\ .select(*something)\ .distinct() x.get_sql(quote_char=False) ``` The quote_char=False doesn't remove the quotes from Cast column name. Actual Result: `"SELECT DISTINCT...
Fix https://github.com/kayak/pypika/issues/238 Fix https://github.com/kayak/pypika/issues/366
