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)


Basic PyPika repo stats
14 days ago

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

PyPika Alternatives

Similar projects and alternatives to PyPika based on common topics and language

  • GitHub repo asyncpg

    A fast PostgreSQL Database Client Library for Python/asyncio. (by MagicStack)

  • GitHub repo django-compositepk-model

    Extended Django Model class with composite-primary-key support

  • GitHub repo Preql

    An interpreted relational query language that compiles to SQL.

  • GitHub repo Skytrax-Data-Warehouse

    A full data warehouse infrastructure with ETL pipelines running inside docker on Apache Airflow for data orchestration, AWS Redshift for cloud data warehouse and Metabase to serve the needs of data visualizations such as analytical dashboards.

  • GitHub repo pampy

    Pampy: The Pattern Matching for Python you always dreamed of.

  • GitHub repo awesome-pattern-matching

    Pattern Matching for Python 3.7+ in a simple, yet powerful, extensible manner.

  • GitHub repo dataset

    Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.

NOTE: The number of mentions on this list indicates mentions on common posts. Hence, a higher number means a better PyPika alternative or higher similarity.


Posts where PyPika has been mentioned. We have used some of these posts to build our list of alternatives and similar projects - the last one was on 2021-02-18.
  • Migrating to SQLAlchemy 2.0 | 2021-02-18
    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: