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).
- Data transformation
- Query Abstraction layer
- SQL server
- flat file
- Multi platform
Be the first to post a review of QAL!