What do you want to change?

In queries like:

SELECT [...]
array_agg(authors.name)::TEXT[] AS author_names,
[...]
GROUP BY [...]

It would be nice to have not only TEXT parsed to string but also the possibility to have it parsed to *string.

Is there a workaround or any plans to implmenet this?

What database engines need to be changed?

postgresql

What programming language backends need to be changed?

GO