How people apparently do this today, is to pass local arrays as SQL arrays via bind is to use the SQL form CALL SP(PARSE_JSON(?)) and then pass a JSON encoded array as string to ?