Here is a thought/topic for discussion & consideration. Many of us work in Google Enterprise Suites (.edu, .org. .gov, etc) where said 'enterprise' is, as you might say, cheap
(ok, fiscally risk averse), and they haven't invested in the complete package(s) that would be required for developing Apps correctly. Meaning, products like Firebase or Firestore are unavailable. To say some of use have abused Sheets as a Database table is being nice. I've used, abused, stretched, and gotten everything I can out of sheets under these circumstances. I treat a sheet (tab) as a DB table, and can link to other sheets, build "merge sheets", etc etc, in this endless "cloud database". To me, importRange === importInfinitePosibility.
With all that in mind, do you folks have any best practices for using sheets as database tables?