How Pony ORM Translates Python Generators to SQL Queries

YouTube·EuroPython

Explore the inner workings of Pony ORM's unique approach to translating Python generators into SQL queries in this conference talk from EuroPython 2014. Dive deep into the multi-stage translation process, including bytecode decompilation, Abstract Syntax Tree (AST) analysis, and SQL generation. Learn about the principles of building a programming language translator, implementation details of Python-to-SQL conversion, and approaches for creating a pluggable translator architecture. Compare Pony ORM's query syntax with other ORMs, and discover additional features like Identity Map, N+1 Query Problem solution, and optimistic locking. Gain insights into the performance implications of this innovative method for constructing SQL queries.