It would be nice to be able to use the ‘CALL’ statement within the SQL integration’s (SQL - Home Assistant) ‘query’ parameter so that stored procedure can be called and promote script re-use rather than having to repeat queries multiple times.
e.g.
- name: Withings - Last Weight Measurements
query: CALL GetStatesList (‘sensor.withings_weight’);
column: “states_list”
This currently errors as it expects a SELECT statement