Similar projects and alternatives to PyPika
Generate type-safe code from SQL
TinyDB is a lightweight document oriented database optimized for your happiness :)
Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
A fast PostgreSQL Database Client Library for Python/asyncio.
Python 3.6+ tkinter table widget for displaying tabular data
High-performance time-series aggregation for PostgreSQL
pickleDB is an open source key-value store using Python's json module.
Extended Django Model class with composite-primary-key support
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
An ORM for S3
A Python feed reader library. (by lemon24)
A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
Statically validate correctness of all your SQL queries. TypeScript, PostgreSQL
SQL builder and utilities library for node.js (runs in browser as well).
Python tool for slicing and dicing SQL
Unfancy node.js SQL builder for ES6
A fast ordered NoSQL database.
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
PyPika reviews and mentions
Write an SQL query builder in 150 lines of Python
10 projects | news.ycombinator.com | 27 Aug 2021
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.
Migrating to SQLAlchemy 2.0
3 projects | news.ycombinator.com | 18 Feb 2021
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
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.