Yes, my grid-tied system is like this. The panels are ~410W and each one has a microinverter with ~390W maximum or something. The more expensive inverters were not worth capturing the peak. You’re better off putting that money into more panels.
Scuba could handle 100,000 columns, probably more. But yes, the model is that you have one table and you can only do self-joins and it’s more or less append only and you were only accessing maybe dozens of columns in a single query.
ClickHouse and Scuba address this. The core idea is the data layout on disk only requires the scan to open files or otherwise access data for the columns referenced in that query.