I have two tables a and b with a many to one relationship.
I know its possible to do a join and get as may records back as my
many relationship has.

But, is it possible to get only one field back as a list.

The result would look like this:

select id. name, magic_list( table_b_types )
from table_a
join table_b on table_a.id = table_b.a_id


id, name, table_b_types
1, "Normal Bees", " worker drone "