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: https://github.com/features/copilot