CAST JSON to Array/Map

Array Conversion JSON Array to SQL Array Map Conversion JSON Object to SQL Map Best Practices Choosing the correct target type ensures your conversions succeed and produce the expected results. Type Specifications When working with these type mappings in real queries, keep performance in mind.