Recently, we talked about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book. This is a description of what comes next after the "low-level" conversion. Warning: it's complicated.

BLUF: Take the time to get rid of SQL processing.

We're talking about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book.

We're talking about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book.

We're talking about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book.

Let's talk about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book.

In the process of writing Unlearning SQL, I had a need to extract SQL blocks from Python programs. Of course, I tried grep. It wasn't ideal.

Big Announcement: the 2024.8 version of Unlearning SQL, and the 2024.9 version of Pivot to Python are available from booksellers online. Both are revised and all the code tested with Python 3.12.

Book (pre) Announcement:

• KDP - See https://www.amazon.com/stores/Steven-Lott/author/B00HNRSLEK for my author's page.

  https://www.amazon.com/Unlearning-SQL-hammer-every-problem-ebook/dp/B0DDMFMXNW is the book.

• Google Play - See https://play.google.com/store/books/details?id=23WAEAAAQBAJ. Be sure to get the 2024.08 edition; there's a previous …

I've published a framework for doing SQL-like programming in Pure Python -- no database required.

Here: https://github.com/slott56/functional-SQL. See the functional-SQL documentation.

This allows us to transform SQL:

SELECT n.name, v.c2
FROM names_table n, values_table v
WHERE n.code = v.c1

To pure Python:

Select(name …