When I first learned about the QUERY function in Google Sheets, I was brought back to the surprisingly large amount of discourse I’ve read regarding spreadsheets and databases, the best of which is contained in Matt Parker’s book Humble Pi. In short, the backbone of spreadsheet software is not designed to let it perform like a database. But because spreadsheets are more explicable, visual, and interactive, businesses and researchers and all other sorts of folk force them into that bucket.
Meta-research has since come out that shows the profound number of accounting and data-reporting errors that proliferate due to the use of spreadsheets as databases. Some of this comes from data type interpretation—what if your gene name is interpreted as a date or currency?—and others come from inherent limitations to how data can be stored and related to each other.
All this well-meaning discussion has tried to guide certain disciplines to take greater care in how they process, store, and access their data. It’s a noble cause, but the humble QUERY function even gets me—someone who perhaps knows better—to forego robust solutions in favor of convenience. So it goes with technology.