pypika

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

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.

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