QAL Icon


Query Abstraction Layer

Add a Review
1 Download (This Week)
Last Update:
  Browse Code Git Repository


QAL is a collection of libraries for mixing, moving, substituting and transforming data from and to SQL databases and files.

Sources and destinations include different database backends, files format like .csv, XML and excel. And even untidy HTML web pages.
It has a database abstraction layer that supports basic connectivity to Postgres, MySQL, DB2, Oracle and MS SQL server.
It uses XML formats(the SQL schema is self-generated) for representation of queries, transformation and merging, making it all scriptable.

With regards to SQL, QAL uses a subset of SQL features and data types, which while not complete however should be sufficient for most usages. It is however easy to instead use backend specific SQL when the queries don't have to be backend-agnostic.

It is currently distributed as a Python Library (.egg) and Debian .deb.

It is related the Optimal BPM project.

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

Update Notifications

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.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.