24ways

Custom SQL query returning 1 row (show)

regexp_matches( 'hello (?P<name>\w+) the (?P<species>\w+)', 'hello bob the dog, hello maggie the cat, hello tarquin the otter' )
[{"name": "bob", "species": "dog"}, {"name": "maggie", "species": "cat"}, {"name": "tarquin", "species": "otter"}]