What does HackerNews think of pypika?

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.

Language: Python

#3 in JavaScript
#164 in Python
#16 in Python
#3 in GraphQL
#44 in SQL
Ask HN: Is SQLAlchemy the industry standard Python ORM in 2023? | Jun 2023
Yes it is. I haven't seen many Python projects using Prisma and I don't believe the arguments in the blog post you've linked to carry much weight.

Note that there are several types of technologies that can help connect an application 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 "standard" here, but you have to use Django. There are a few, alternatives, that are probably worth investigating if you want to use this pattern. - ORMs that follow the unit of work pattern: here I think SLQAlchemy ORM has very little competition.

An interesting discussion can be found here: https://www.youtube.com/watch?v=x1fCJ7sUXCM

Write an SQL query builder in 150 lines of Python | Aug 2021
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 and nuances of rolling your own SQL generator.

Migrating to SQLAlchemy 2.0 | Feb 2021
Expand Context ↕
There is a middle-ground between writing SQL statement strings in your code, and a full-blown ORM: query builders. At least in my experience with small to medium projects, these have far fewer footguns while keeping the code composable and readable. Here's one for Python: https://github.com/kayak/pypika