Skip to main content

An interpreted relational query language that compiles to SQL

Project description

alt text

Preql (pronounced: Prequel) is an interpreted, relational programming language, that specializes in database queries.

It is designed for use by data engineers, analysts and data scientists.

Preql's main objective is to provide an alternative to SQL, in the form of a high-level programming language, with first-class functions, modules, strict typing, and Python integration.

How does it work?

Preql code is interpreted and gets compiled to SQL at runtime. This way, Preql gains the performance and abilities of SQL, but can also operate as a normal scripting language.

Currently supported dialects are:

  • Postgres
  • MySQL
  • Sqlite
  • BigQuery (soon)
  • More... (planned)

For features that are database-specific, or aren't implemented in Preql, there is a SQL() function that provides a convenient escape hatch to write raw SQL code.

Main Features

  • Modern syntax and semantics
    • Interpreted, everything is an object
    • Strong type system with gradual type validation and duck-typing
  • Compiles to SQL
  • Python and Pandas integration
  • Interactive shell (REPL) with auto-completion
  • Runs on Jupyter Notebook

Note: Preql is still work in progress, and isn't ready for production use, or any serious use quite yet.

Learn More

Get started

Simply install via pip:

    pip install -U preql-lang

Then just run the interpreter:

    preql

Requires Python 3.8+

Read more

Quick Example

// The following code sums up all the squares of an aggregated list of
// numbers, grouped by whether they are odd or even.

func sum_of_squares(x) = sum(x * x)
func is_even(x) = (x % 2 == 0)

// Create a list of [1, 2, 3, ..., 99]
num_list = [1..100]

// Group by is_even(), and run sum_of_squares() on the grouped values.
print num_list{ is_even(item) => sum_of_squares(item) }

// Result is:
┏━━━━━━━━━┳━━━━━━━━┓
 is_even  sqrsum 
┡━━━━━━━━━╇━━━━━━━━┩
       0  166650 
       1  161700 
└─────────┴────────┘

In the background, this was run by executing the following compiled SQL code (reformatted):

  WITH range1 AS (SELECT 1 AS item UNION ALL SELECT item+1 FROM range1 WHERE item+1<100)
  SELECT ((item % 2) = 0) AS is_even, SUM(item * item) AS sqrsum FROM range1 GROUP BY 1;

License

Preql uses an “Interface-Protection Clause” on top of the MIT license.

See: LICENSE

In simple words, it can be used for any commercial or non-commercial purpose, as long as your product doesn't base its value on exposing the Preql language itself to your users.

If you want to add the Preql language interface as a user-facing part of your commercial product, contact us for a commercial license.

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

preql-lang-0.1.17.tar.gz (72.6 kB view details)

Uploaded Source

Built Distribution

preql_lang-0.1.17-py3-none-any.whl (82.1 kB view details)

Uploaded Python 3

File details

Details for the file preql-lang-0.1.17.tar.gz.

File metadata

  • Download URL: preql-lang-0.1.17.tar.gz
  • Upload date:
  • Size: 72.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.1.2 CPython/3.8.2 Windows/10

File hashes

Hashes for preql-lang-0.1.17.tar.gz
Algorithm Hash digest
SHA256 a11f6b53faac5f5972d8d97af84042396dba3e6d9a0e7a5b19f960950d3e8303
MD5 f8c59650f174dd7efeb8b86d95166eeb
BLAKE2b-256 bcda15022bf9b425e73deef892a4309f55153e41d533b695a4f80d3067663446

See more details on using hashes here.

File details

Details for the file preql_lang-0.1.17-py3-none-any.whl.

File metadata

  • Download URL: preql_lang-0.1.17-py3-none-any.whl
  • Upload date:
  • Size: 82.1 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.1.2 CPython/3.8.2 Windows/10

File hashes

Hashes for preql_lang-0.1.17-py3-none-any.whl
Algorithm Hash digest
SHA256 5d62aa28d3d4ff41e6341dd9cd1b1e60908081f90b26766ee78bff955b3d347b
MD5 83d3602ea316e1f0367d611bca9c06ce
BLAKE2b-256 37f4e1cc36e3442df6a7904a86619f6db55202d528163b8fc383e9d6c3b86296

See more details on using hashes here.

Supported by

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