Skip to main content

Build SQL with native Python data structure smoothly.

Project description

The full version of this documentation is at

MoSQL — More than SQL

It lets you use the common Python data structures to build SQLs. Here are the main features:

  1. Easy-to-learn — Everything is just a plain Python object or SQL keyword.
  2. Flexible — The query it builds fully depends on the structure you provide.
  3. Secure — It prevents the SQL injection from both identifier and value.
  4. Fast — It simply translates the Python data structures into SQLs.

It is just more than SQL.

MoSQL is Elegant

Here we have a dictionary which includes the information of a person:

>>> mosky = {
...    'person_id': 'mosky',
...    'name'     : 'Mosky Liu',
... }

And we want to insert it into a table named person. It is easy with mosql.query:

>>> from mosql.query import insert
>>> print(insert('person', mosky))
INSERT INTO "person" ("person_id", "name") VALUES ('mosky', 'Mosky Liu')

Check The Common Queries — mosql.query for detail, or there are examples which interact with real database.

Like it?

It is available on PyPI:

$ sudo pip install mosql

Or clone the source code from GitHub:

$ git clone git://

Project details

Download files

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

Files for mosql, version 0.12.3
Filename, size File type Python version Upload date Hashes
Filename, size mosql-0.12.3.tar.gz (38.5 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page