QAL is a abstraction layer for running backend-agnostic SQL-statements, mixing and moving data from different data sources into and out of SQL databases.
Sources include different database backends, files and web pages.
For database connectivity, it has a database abstraction layer that supports basic connectivity to Postgres, MySQL, DB2, Oracle and MS SQL server.
It uses a XML format(whose schema it generates itself) for representation of queries.
It is distributed as a Python Library (.egg) and uses (and therefore needs) an SQL server database to build SQL queries and handle datasets.
As the different SQL backends have significant differences in their SQL implementations, only the most important statements are generalized, and QAL uses a simplified range of SQL features and data types, which however should be sufficient for most usages. It is however possible to include backend specific custom SQL:s if needed.
Be the first to post a review of QAL!