Using sequence as parameters

[freud14-tm]

I know that using sequence as parameters works using the legacy inline parameters. However, as mentioned there, it doesn't work with the native parameters. Is this somewhere on the roadmap to be implemented? If so, when?

[susodapop]

Is this somewhere on the roadmap to be implemented?

Yes. For this to work, Databricks runtime needs to support ARRAY type SQL parameters. That feature is being designed right now.

If so, when?

I don't have an ETA to share at this time. But I've passed this specific use-case to that team for consideration.

[freud14-tm]

Thank you very much @susodapop . Let me know of the development.

[susodapop]

From what I understand, the likely syntax for this construct in the future would be like this:

SELECT field FROM table WHERE field in (SELECT * FROM explode(:array_param))

...although it would be nice to have a better shorthand for this.