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 …

I started with the Apple Books platform because it's an easy default for me.

First, there's

https://www.pythonpodcast.com/sqlfluff-sql-linter-episode-318/

This cropped up recently. It's part of a "replace Mongo with Relational DB" conversation.

I'm going to elide the conversation down to five key points. The three post-hoc nonsensical ideas, and the two real points.

What's (to me) very telling is that someone else published the five reasons in this …