4 ms·Web based spreadsheets are one sweet spot. Generally simplest and most flexible are conflicting requirements.by fulafel 7y agoWeb based spreadsheets are one sweet spot. Generally simplest and most flexible are conflicting requirements.amolo 7y agolimited querying capabilities though.fulafel 7y agoYep. There are some clunky escape hatches (you can use simple SQL in QUERY() or script in JS etc) in Google Sheets at least. But you should use or migrate to something else if you know you're going to need them.