Ask HN: Is SQLAlchemy the industry standard Python ORM in 2023?

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com
featured
Stream - Scalable APIs for Chat, Feeds, Moderation, & Video.
Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.
getstream.io
featured
  1. Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

    I'm starting a greenfield side project. I've only used Python in smaller projects without reason to hook up an ORM tool. In searching for choices now, the de facto standard seems to be SQLAlchemy, but I also see a number of references to Prisma[0][1] and other projects that claim to be a better, modern choice. What is the right choice for a brand new project at this time?

    [0] https://github.com/prisma/prisma

    [1] https://eash98.medium.com/why-sqlalchemy-should-no-longer-be-your-orm-of-choice-for-python-projects-b823179fd2fb

  2. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  3. 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.

    Yes it is. I haven't seen many Python projects using Prisma and

    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.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • any recommendations for a good query builder library with good support?

    2 projects | /r/learnpython | 11 Jul 2023
  • Maintenance of popular ORMs (explanation inside)

    7 projects | /r/node | 22 Nov 2022
  • Minimal Linktree-style web app built with Next.js 15, Prisma, BetterAuth, and ShadCN/UI.

    2 projects | dev.to | 21 Jun 2025
  • Project of the Week: Prisma

    1 project | dev.to | 2 May 2025
  • Sqlc: Generate type-safe code from SQL

    1 project | news.ycombinator.com | 16 Apr 2025

Did you know that Python is
the 2nd most popular programming language
based on number of references?