SQLAlchemy & Copilot Pt 3 - Running Queries (Дата оригинальной публикации: )

Part three of a three-part series on SQL Alchemy 2.0 & GitHub Copilot with Pamela Fox. 0:00 Intro 0:30 Querying for all rows 0:55 Prompting Copilot for SQLAlchemy 2.0 queries 1:39 Using scalars 2:31 Querying with WHERE filters 2:59 Querying with GROUP BY 3:51 Querying related data 4:19 Querying 1-to-many relationships 5:06 Summary In part three of this series, join Pamela Fox as she uses SQLAlchemy 2.0 to query the data in a relational SQLite database, including WHERE clauses, GROUP BY, and JOINs on relational data. She uses Copilot to help write the queries, starting off with a prompt that ensures Copilot uses the modern SQLAlchemy 2.0 API. More #copilot info: