Any alternatives to SQLAlchemy Core for a "query builder" library?

This page summarizes the projects mentioned and recommended in the original post on

Our great sponsors
  • InfluxDB - Build time-series-based applications quickly and at scale.
  • Sonar - Write Clean Python Code. Always.
  • Zigi - Delete the most useless function ever: context switching.
  • Scout APM - Truly a developer’s best friend
  • hissdb

    a SQLite query builder with a few bells and whistles

    It definitely doesn't qualify as popular, but I wrote HissDB, a query builder for SQLite that sounds a bit like what you're describing.

  • sqllex

    The most pythonic ORM (for SQLite and PostgreSQL). Seriously, try it out!

    FYI: If you're looking for something with more than one user, take a look at sqllex, which is a great query builder along the same lines. I made HissDB because sqllex didn't parameterize its queries, but I believe they've fixed that issue since then.

  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Data Platform where developers build real-time applications for analytics, IoT and cloud-native services in less time with less code.

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