Pandasql allows you to query pandas DataFrames using SQL syntax
Here is a sample of crud interface with python for the Database systens presented in the course.
Simple DDL ParserSimple DDL Parser to parse SQL (HQL, TSQL, AWS Redshift, Snowflake and other dialects) ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc. Build
sqlparse is a non-validating SQL parser for Python. It provides support for parsing, splitting and formatting SQL statements.
Pony is an advanced object-relational mapper. The most interesting feature of Pony is its ability to write queries to the database using Python generator expressions and lambdas.
The orm package is an async ORM for Python, with support for Postgres, MySQL, and SQLite.
Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.
The package gives you ORM for PyPika with asycio support for a range of databases (SQLite, PostgreSQL, MySQL).
In the paper, we present TAPEX (for Table Pre-training via Execution)
A tool to practice SQL queries. Start DB, populate it with random data and write queries