Very cool! I built a company around SQL and Google Sheets (https://www.seekwell.io/, acquired by ThoughtSpot in 2022). Plenty of opportunity there.
You get a lot of this for free in duckdb. e.g. if you run the query below from the duckdb CLI, it'll query the sheet[0]:
SELECT *
FROM read_csv_auto('https://docs.google.com/spreadsheets/export?format=csv&id=1GuEPkwjdICgJ31Ji3iUoarirZNDbPxQj_kf7fd4h4Ro', normalize_names=True);
We use duckdb under the hood at my new company (https://www.definite.app/), so we get this same sort of functionality for free.0 - https://twitter.com/thisritchie/status/1767922982046015840