MySQL Command

[Yes]

I was browsing through the list of available official HA integrations when
I came across the SQL integration. Could this be what you’re looking for?

I haven’t tried it myself (yet), but it seems it lets one create sensors based on SQL Queries. Not just for MySQL databases but for other DB engines as well.
With sensors you should be able to display the retrieved values in Lovelace without a user having to press a button etc.
You will still need a query per entity I guess.

SQL

Forum thread that discusses how to handle query updates.

(Re-)enable scan_interval on the SQL integration

I can confirm that the workaround with manually updating the sensors with homeassistant.update_entity after disabling the polling on the SQL integration did in fact work. Around half of my integration does not have a disable polling switch, but, as you said, they were push integrations. My bad (and, I didn’t even know about that switch anyway, before you told me!). I sometimes do see a use case for manually updating something that is “push”. Some of my power monitoring plugs are updating their …