Goals of SQL-API

  • Representation of SQL in Python objects
  • Late binding of expressions to database backends
  • Parse connection URIs
  • Load database backend drivers as plugins
  • Create DB-API connections
  • Pooling
  • Logging of queries
  • Database portability
  • Provide DB-API exceptions that are not driver-specific

Non-Goals

  • Abstractions beyond SQL syntax