QAL Icon


Query Abstraction Layer

Add a Review
3 Downloads (This Week)
Last Update:
  Browse Code Git Repository


[See the files section for installation instructions]

QAL is a collection of libraries for mining, transforming and writing data from and to a number of places.

Sources and destinations include different SQL and NoSQL backends, file formats like .csv, XML and excel. Even untidy HTML web pages.
It has a database abstraction layer that supports connectivity to Postgres, MySQL, DB2, Oracle, MS SQL server. JSON and MongoDB is coming.
It uses XML/JSON formats(self-generated SQL schemas) for representing queries, transformation and merging, making it scriptable.

This means that QAL can be backend agnostic about a subset of SQL features and data types. Of course custom SQL:s are also supported.

It is currently distributed as a Python 3 Library (pip3 install python3-qal) and Debian .deb package.

It is related the Optimal BPM project, see its Optimal Sync application for usage examples.

The text of this page is released under the Creative Commons Zero Waiver 1.0 (CC0).

QAL Web Site


  • Data transformation
  • Query Abstraction layer
  • Oracle
  • DB/2
  • PostgresSQL
  • MySQL
  • SQL server
  • flat file
  • XML
  • Python
  • Merge
  • Multi platform


Write a Review

User Reviews

Be the first to post a review of QAL!

Additional Project Details

Intended Audience

Information Technology, Financial and Insurance Industry, Science/Research, Legal Industry, Architects, Engineering

Programming Language



Screenshots can attract more users to your project.
Features can attract more users to your project.