---

SELECT
    'dev' AS schema_name,
    to_jsonb(qt) AS table_definition
FROM dev.query_table qt
WHERE to_jsonb(qt) ->> 'code' = 'qN5iq9gb'

UNION ALL

SELECT
    'dev_local' AS schema_name,
    to_jsonb(qt) AS table_definition
FROM dev_local.query_table qt
WHERE to_jsonb(qt) ->> 'code' = 'qN5iq9gb';




SELECT
    a.id AS query_action_id,
    to_jsonb(a) ->> 'name' AS action_name,
    c.id AS command_id,
    to_jsonb(c) ->> 'name' AS command_name,
    c.command
FROM dev.query_action a
LEFT JOIN dev.query_action_command c
    ON c.query_action_id = a.id
WHERE to_jsonb(a) ->> 'code' = 'Cjp6JXSq'
ORDER BY c.ordinal, c.id;