Fulcrum choice values from forms table element, data_name

gist.sql

WITH RECURSIVE nested_elements AS (
    SELECT jsonb_array_elements(elements::jsonb) AS element
    FROM forms
    WHERE name = 'Structure Brushing 2025'
    UNION ALL
    SELECT jsonb_array_elements(element->'elements')
    FROM nested_elements
    WHERE element ? 'elements'
)
SELECT 
    element->>'choices' AS choices
FROM 
    nested_elements
WHERE 
    element->>'data_name' = 'environmental_survey_type_visit_1';