PyPika is a programmatic interface that uses a natural, pythonic syntax for creating SQL queries without assumptions. It is intended for querying analytical data and supports analytic queries but is designed as a light-weight wrapper that is extensible to any SQL syntax.
What's the difference between this Python project and similar ones?
Light-weight wrapper using pythonic syntax
Uses the builder pattern with immutability for dynamic construction of queries and re-use of query parts
Supports complex queries with arithmetic, functions, and nested expressions
Supports analytic queries
No assumptions made, extensible to any SQL syntax and database
--
Anyone who agrees with this pull request could vote for it by adding a 👍 to it, and usually, the maintainer will merge it when votes reach 20.
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.
## 📋 Pull Request Information
**Original PR:** https://github.com/vinta/awesome-python/pull/915
**Author:** [@twheys](https://github.com/twheys)
**Created:** 8/15/2017
**Status:** ❌ Closed
**Base:** `master` ← **Head:** `pypika-add`
---
### 📝 Commits (4)
- [`49286f0`](https://github.com/vinta/awesome-python/commit/49286f0dc15d04c6c649c7c2d1ba47ff24aeb680) Added pypika to ORM Relational Databases
- [`91307e9`](https://github.com/vinta/awesome-python/commit/91307e9e130d4c7a6216ce6dbb5d301ae9d4f897) Merge branch 'master' into pypika-add
- [`f74794c`](https://github.com/vinta/awesome-python/commit/f74794c9209205b1b046473d80655bb68961b58b) Update README.md
- [`195d1a7`](https://github.com/vinta/awesome-python/commit/195d1a7e46fc81cb2913ea5191acfb9b5ea5ae65) Update README.md
### 📊 Changes
**1 file changed** (+1 additions, -0 deletions)
<details>
<summary>View changed files</summary>
📝 `README.md` (+1 -0)
</details>
### 📄 Description
## What is this Python project?
PyPika is a programmatic interface that uses a natural, pythonic syntax for creating SQL queries without assumptions. It is intended for querying analytical data and supports analytic queries but is designed as a light-weight wrapper that is extensible to any SQL syntax.
## What's the difference between this Python project and similar ones?
- Light-weight wrapper using pythonic syntax
- Uses the builder pattern with immutability for dynamic construction of queries and re-use of query parts
- Supports complex queries with arithmetic, functions, and nested expressions
- Supports analytic queries
- No assumptions made, extensible to any SQL syntax and database
--
Anyone who agrees with this pull request could vote for it by adding a :+1: to it, and usually, the maintainer will merge it when votes reach **20**.
---
<sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
📋 Pull Request Information
Original PR: https://github.com/vinta/awesome-python/pull/915
Author: @twheys
Created: 8/15/2017
Status: ❌ Closed
Base:
master← Head:pypika-add📝 Commits (4)
49286f0Added pypika to ORM Relational Databases91307e9Merge branch 'master' into pypika-addf74794cUpdate README.md195d1a7Update README.md📊 Changes
1 file changed (+1 additions, -0 deletions)
View changed files
📝
README.md(+1 -0)📄 Description
What is this Python project?
PyPika is a programmatic interface that uses a natural, pythonic syntax for creating SQL queries without assumptions. It is intended for querying analytical data and supports analytic queries but is designed as a light-weight wrapper that is extensible to any SQL syntax.
What's the difference between this Python project and similar ones?
--
Anyone who agrees with this pull request could vote for it by adding a 👍 to it, and usually, the maintainer will merge it when votes reach 20.
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.