This had drifted. In the previous commit I inserted the ping check at number 100. Hindsight: should have added that as 140 and renamed it in a followup commit.
Add a set returning function that fetches a particular key. It can be called like:
SELECT * FROM consul_kv_get('foo-key');
SELECT * FROM consul_kv_get(key := 'test/', recurse := TRUE);