Query Abstraction Layer

Query Abstraction LayerDeveloper(s)| Nicklas Börjesson

|

Initial release| September 2013 (2013-09)[1]
Stable release|

0.4.0[2] / October 31, 2014 (2014-10-31)

Written in| Python
Operating system| Cross-platform
License| BSD license
Website| www.optimalbpm.se/wiki/index.php/QAL

QAL is an open-source development project that aims to create a collection of libraries for mixing, moving, merging, substituting and transforming data;[3] also in some cases, such as MongoDB, schemas.

## Description

Sources and destinations include different database backends, file formats like `.csv`, XML and spreadsheets. Even untidy HTML web pages can be used as both a source and destination.

For SQL/RDBMS backends, it has a database abstraction layer that supports basic connectivity to Postgres, MySQL / MariaDB, IBM Db2, Oracle and MS SQL Server.[4] It uses XML formats (the SQL schema is self-generated) for representation of queries, transformation and merging, making it all processable by scripts.

With regards to SQL, QAL uses a subset of SQL features[5] and data types,[6] which while obviously not complete however is sufficient for most usages. It is however easy to instead use backend-specific SQL when the queries do not have to be backend-agnostic.

It is currently distributed as a Python Library (`.egg`)[7] and a Debian package file (`.deb`).[8]

It is related to the Optimal BPM (Business Process Management) project.[9] The Optimal BPM SourceForge project used to be DAL/QAL.[1]

## References

1. ↑ 1.0 1.1 Commits breaking it out of Optimal BPM
2. ↑ Release news
3. ↑ Sourceforge project page
4. ↑ Database backends
5. ↑ SQL features supported
6. ↑ SQL data types
7. ↑ PyPi repository page
8. ↑ Downloadable files
9. ↑ Optimal BPM site

## External links

* QAL Documentation and examples
* API documentation

0.00

(0 votes)

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Query_Abstraction_Layer&oldid=3898416"