Blocked from using database function that should work

[bporterfield]

What happens?

Trying to use array_agg! on a dimension from a join_many but being told "Cannot use a scalar field in a measure declaration, did you mean to use a dimension declaration instead?". Using the internal string_agg does work on the same dimension though...

To Reproduce

Join many something and try to do aggregating database function on a joined dimension

OS:

macOS

Malloy Client:

local VSCode

Malloy Client Version:

latest

Database Connection:

Postgres