Search Results for "sqlite query builder"

athenaSQL is Athena SQL query builder, inspired by sparkSQL. It borrow some sparkSQL’s concept sparkSQL. It was initially designed to eliminate the need for hard-coding SQL queries as strings within Python scripts and as an alternative to any bespoke SQL query templating. However, it offers the flexibility to be used in various ways as needed.

Audax Data Manager is the SQL Editor that's fast enough for a one-off query, and powerful enough for backups, performance tuning, and database design. Supports PostgreSQL, SQLite, Microsoft SQL Server, MySQL, MariaDB, and Oracle. Works on Linux, Windows and Mac. Explore and edit your data, write SQL queries with smart autocomplete, monitor database performance, run background backups and more!

Records is a Python library designed to make direct SQL querying convenient without introducing a full object-relational mapper. It supports relational databases including PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, and Amazon Redshift through SQLAlchemy. Query results are exposed as friendly Record objects whose fields can be accessed by attribute, key, or numeric index. Queries support safe parameterization, SQL files, transactions, and bulk operations. Result collections can be converted into dictionaries or exported through Tablib to formats such as CSV, JSON, Excel, HTML, YAML, and Pandas DataFrames. ...