Skip to main content

Lightweight Python SQL query builder with support for multiple dialects: ClickHouse, PostgreSQL, DuckDB, MySQL and SQLite

Project description

david8

david8 is a lightweight Python SQL builder with zero dependencies. Clean API. Safe parameters. No ORM magic.

No manual parameter naming. Just pass values - david8 handles the rest:

.where(eq('age', 18), lt('score', 100))
# WHERE age = %(p1)s AND score < %(p2)s
# {'p1': 18, 'p2': 100}

100% test coverage · thousands of downloads

Built-in dialect support: ClickHouse · DuckDB · PostgreSQL · MySQL · SQLite

See Wiki

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

david8-1.4.0b1.tar.gz (28.6 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

david8-1.4.0b1-py3-none-any.whl (26.4 kB view details)

Uploaded Python 3

File details

Details for the file david8-1.4.0b1.tar.gz.

File metadata

  • Download URL: david8-1.4.0b1.tar.gz
  • Upload date:
  • Size: 28.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for david8-1.4.0b1.tar.gz
Algorithm Hash digest
SHA256 b48974fb45122f06f44c0a1d23d1ede4d1d2d7bff77b2a385dc0cd4a9c03663d
MD5 10db9c51ae10225a136842e7844d9e3d
BLAKE2b-256 9e31aea250104726664c5aac74c02da8e640859301f6d05972b5813fd1461358

See more details on using hashes here.

File details

Details for the file david8-1.4.0b1-py3-none-any.whl.

File metadata

  • Download URL: david8-1.4.0b1-py3-none-any.whl
  • Upload date:
  • Size: 26.4 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for david8-1.4.0b1-py3-none-any.whl
Algorithm Hash digest
SHA256 d60bf58497f48d5dff0274be54a89098c75602bd5bb67be1881417d37902e4d6
MD5 8f1a9ecea9c1d0ef9f0a31e58bc84a68
BLAKE2b-256 3214a405b63c6f1077e1d56e90cf6c69e8b4e8a628404e1e7440a2795bc4657a

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page