Sick of restricted possibilities in plain SQL?

Empower your ETL processes

With SQL, R, Python and templates, your Transform processes will be on another level

Concepts

Develop and manage your transformations like code

Software development has come a long way and establishes many very useful concepts and processes. With LESQL you can reuse these for your data transformations.

DRY - Don't Repeat Yourself

The DRY concept is commonly used in software development. Now it is possible in data as well.

With so called global models, you can use your SQL code for many projects, but only manage it once. For example if you have to create the same analysis for several customers.

Secure

Database credentials for all your projects (customers) are stored centralized and encrypted. So your analystis don't need to handle these

Credentials can be stored in

  • Files (e.g. managed by git)
  • Etcd (coming soon)
  • Vault (coming soon)

Features

NO INSTALL MESS

Single binary

If you just want to use SQL, all you have to do is to download one single binary and you are good to go

RUN IT WHERE YOU WANT

Runs on MacOS, Linux and Windows

We provide binaries for all major platforms.

NOT LIMITED TO SQL

Templates, Python and R

Sometimes SQL could be very limited. Therefore we added a template engine (from Go). Python and R support will come soon.

Start for free

It is open source

Getting started