SNOW-679254: Properly support arrays as returned type

[Thomasdezeeuw]

Issue description

Currently arrays are returned a strings, which is not ideal because that means we have to parse those manually.

[yevgenypats]

Hi there! I also stumbled upon this and I would add that it's not a question of ideal or not but rather there is no way to parse as if there is something like "," inside a string saved in a string array you wont be able to distinguish between what is part of the array and what is part of the string in go.

[sfc-gh-dszmolka]

thank you for raising this issue - even bigger thank you to yevgenypats for answering it. closing it for now, but if there's a PR which could address the requirement I'm happy to reopen to move forward

[Thomasdezeeuw]

@sfc-gh-dszmolka did you read @yevgenypats comment? He agrees with me adding that's not possible to parse the array as text.

[Thomasdezeeuw]

@sfc-gh-dszmolka can you reopen this as it's not solved.

[sfc-gh-dszmolka]

reopening the issue and marking it as an enhancement for the product team to pick up in a later time

[sfc-gh-pfus]

Hi all, thank you for your patience. Snowflake introduced a concept of structured types (doc). Driver also supports these types since version 1.11.0 (doc).