kayak/pypika
View on GitHub ↗ ★ 2,924 Python
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.
3 mentions on Hacker News by 3 people: 0 stories, 3 comments · first 2021-02-18 · latest 2023-06-12
20082026
-
…to an SQL database: - SQL builders: the best known project seems to be Pypika by Kayak ( https://github.com/kayak/pypika ) but it seems to be dead of sleeping. - ORMs that follow the active record pattern: Django's ORM is obviously the…
comment by fermigier · 2023-06-12 · in Ask HN: Is SQLAlchemy the industry standard Python ORM in 2023? -
I highly recommend pypika by Kayak: https://github.com/kayak/pypika Have used in multiple projects and have found it's the right balance between ORMs and writing raw SQL. It's also easily extensible and takes care of the many edge cases…
comment by bluehark · 2021-08-27 · in Write an SQL query builder in 150 lines of Python -
…have far fewer footguns while keeping the code composable and readable. Here's one for Python: https://github.com/kayak/pypika
comment by bityard · 2021-02-18 · in Migrating to SQLAlchemy 2.0