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. (by kayak)

PyPika Alternatives

Similar projects and alternatives to PyPika

  1. Prisma

    487 PyPika VS Prisma

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

  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. sqlc

    182 PyPika VS sqlc

    Generate type-safe code from SQL

  4. pydantic

    181 PyPika VS pydantic

    Data validation using Python type hints

  5. drizzle-orm

    77 PyPika VS drizzle-orm

    Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

  6. slonik

    74 PyPika VS slonik

    A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

  7. litestar

    33 PyPika VS litestar

    Production-ready, Light, Flexible and Extensible ASGI API framework | Effortlessly Build Performant APIs

  8. reader

    30 PyPika VS reader

    A Python feed reader library. (by lemon24)

  9. Stream

    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.

    Stream logo
  10. sqlmodel

    26 PyPika VS sqlmodel

    SQL databases in Python, designed for simplicity, compatibility, and robustness.

  11. asgiref

    21 PyPika VS asgiref

    ASGI specification and utilities

  12. asyncpg

    18 PyPika VS asyncpg

    A fast PostgreSQL Database Client Library for Python/asyncio.

  13. databases

    17 PyPika VS databases

    Async database support for Python. 🗄

  14. attrs

    13 PyPika VS attrs

    Python Classes Without Boilerplate

  15. tortoise-orm

    12 PyPika VS tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

  16. TinyDB

    8 PyPika VS TinyDB

    TinyDB is a lightweight document oriented database optimized for your happiness :)

  17. PipelineDB

    High-performance time-series aggregation for PostgreSQL

  18. psycopg

    9 PyPika VS psycopg

    New generation PostgreSQL database adapter for the Python programming language

  19. pickleDB

    0 PyPika VS pickleDB

    pickleDB is an in memory key-value store using Python's orjson module for persistence.

  20. dbj

    0 PyPika VS dbj

    Discontinued Simple embedded in memory json database

  21. SSShelf

    0 PyPika VS SSShelf

    An ORM for S3

  22. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better PyPika alternative or higher similarity.

PyPika discussion

Log in or Post with

PyPika reviews and mentions

Posts with mentions or reviews of PyPika. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-10-24.

Stats

Basic PyPika repo stats
5
2,697
5.7
8 months ago

kayak/pypika is an open source project licensed under Apache License 2.0 which is an OSI approved license.

The primary programming language of PyPika is Python.


Sponsored
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

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