Creator of Facata here. DBAPI 2 is the standard for accessing SQL databases from Python, but since it's about 20 years old now, I thought I'd have a go at updating it in the form of a Python library that's a wrapper for DBAPI 2 driver. The main differences with DBAPI 2 are:
* DBAPI 2 has five ways of writing parameters in SQL, but Facata has just one.
* In DAPI 2 parameter values can be provided as a sequence or mapping, but in Facata parameter values are provided as keyword arguments.
* DBAPI 2 has four levels of threadsafety, but Facata just has one.
* DBAPI 2 has a 'cursor' object, but in Facata there is no cursor object and statements are executed using the connection.
* DBAPI 2 overrides the autocommit mode of the underlying database by silently sending START TRANSACTION statements if a transaction isn’t already in progress. Facata never silently sends SQL statements.
All feedback gratefully received :-)