Skip to main content

Write queries in SQL.

Project description

# SQL-query

SQL is a fantastic language — one of the most successful programming languages in the world. We should use it, not try to replace it with a bespoke DSL.

Yet there are a couple of things that are nice to have help with in constructing SQL queries:

  • dialect-aware safe value substitution: Every database interface has its own syntax for substituting values safely (not to allow SQL injection) — for example, $1 or ? or :varname. They also have different requirements for the format of the sql + values argument lists. I want to able to write my queries with the same value substituion syntax, regardless of which database interface I am using, and know that the SQL will be output correctly for my interface, and that the values will be passed to the database engine safely.

  • dynamic attributes: In many applications, I don’t know in advance which attributes I am going to select, insert, update, or filter by. I want to SELECT a given list of attributes, or filter WHERE a given key/value mapping, or UPDATE or INSERT particular attributes, without having to rewrite the SQL query.

  • block composition: Some SQL queries are very complex. I want to able to compose blocks of SQL into larger queries, so that I can manage this complexity effectively. (Most database query DSLs are unable to deal with complex queries, or they invent a hard-to-learn language for writing those queries. Learning SQL is a better use of our time, but having some assistance managing/manipulating the different blocks in a query would be very helpful.)

Behold SQL-query: [OUTDATED]

  • One class, SQL, with one field, query, and one method, .render, which takes one optional argument, dialect.

  • Dynamic value replacement, rendered in one of the supported dialects: postgresql ($1), sqlalchemy (:varname), embedded (:varname), mysql (%(varname)s), sqlite (?). Default style is :varname.

  • Dynamic attribute/value lists in SELECT, WHERE, INSERT, and UPDATE syntax via ??? [TBD]

  • Block composition via ??? [TBD]

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

sql-query-0.4.1.tar.gz (3.4 kB view details)

Uploaded Source

Built Distribution

sql_query-0.4.1-py2.py3-none-any.whl (9.6 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file sql-query-0.4.1.tar.gz.

File metadata

  • Download URL: sql-query-0.4.1.tar.gz
  • Upload date:
  • Size: 3.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.7.3

File hashes

Hashes for sql-query-0.4.1.tar.gz
Algorithm Hash digest
SHA256 93dbf4f1856c4a5b5b2eb9ebaf9c1b3d4fbb5f762bede503c42e8f3198e856e4
MD5 f16fd1e950a8789cf3e59379b8664eae
BLAKE2b-256 55a05a95349bb1708a21a33b37f453be828f8166a2ea87f42ad3d1b6d0826567

See more details on using hashes here.

File details

Details for the file sql_query-0.4.1-py2.py3-none-any.whl.

File metadata

  • Download URL: sql_query-0.4.1-py2.py3-none-any.whl
  • Upload date:
  • Size: 9.6 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.7.3

File hashes

Hashes for sql_query-0.4.1-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 22c87c30f11aa6be982a13f53770603bf4f6d1c776dd99de8e11cca0a3a93b9b
MD5 4ef7a2236d1edbebe4348a8535317ae1
BLAKE2b-256 7378689470fb5f9ea86d634bf9b8715396cfaa2e292ca2d7a2c216050d907452

See more details on using hashes here.

Supported by

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