Spreadsheets and Queries
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. ...