This is true, but FWIW (it probably wouldn't save you here, too much is changing too fast) something like a SQL materialized view can very often give you both t

This is true, but FWIW (it probably wouldn't save you here, too much is changing too fast) something like a SQL materialized view can very often give you both the chocolate and the peanut butter.