Mayim: Bring Your Own Query - Intro to the non-ORM SQL client

PyGeekle '22

ORMs are great, except when they are not. Ever been working with an ORM and feel like you need to jump through hoops to get the queries you want? But, you do not want to dropdown to the low-level clients and give up your nicely annotated models.

This is where Mayim fits in. The DB client that executes your hand-written SQL queries, and hydrates them into models.

In this talk we will cover:

• the benefits to writing your own SQL
• how Mayim can be used to handle complex data models
• integration options into web frameworks like Sanic