SQLAlchemy Query Builder¶
Uvicore provides 3 Layers of database access. Here we discuss forgoing the Uvicore ORM and the Uvicore Query Builder and jump straignt into SQLAlchemy's own Query Builder!
Generally the ORM is the best way to utilize and query your tables. And if you prefer to skip the ORM, give the Uvicore Query Builder a shot. It's simple and elegant.
However, if you need ultimate SQLAlchemy power, keep reading!
Note
A prerequisite to using SQLAlchemy's Query Builder is to define your DB Tables. If you prefer zero table definitions, then SQLAlchemy RAW SQL may be for you!