qiorm

Qiorm is a Python library designed to simplify database interactions by providing an object-relational mapper (ORM) and a query builder. It aims to offer a more Pythonic way to work with databases compared to traditional SQL queries. Qiorm allows developers to define database models as Python classes and then interact with the database using these objects. This approach abstracts away much of the underlying SQL, making code more readable and maintainable.

The library supports various database backends, including PostgreSQL, MySQL, and SQLite, through SQLAlchemy. Qiorm's query builder enables the construction of complex queries in a fluent and expressive manner, avoiding the need to write raw SQL strings for many common operations. It handles tasks such as data validation, type casting, and relationship management between different database tables. By mapping database tables to Python classes and table rows to instances of these classes, Qiorm facilitates operations like creating, reading, updating, and deleting (CRUD) data with a reduced chance of SQL injection vulnerabilities. The goal is to increase developer productivity and reduce the cognitive load associated with database programming.