#30426 is adding the ability to query into JSON collections. Indexing (AKA ElementAt) is supported, but currently is translated to SQL subquery syntax; while this is the right thing for relational (will work on any provider), most databases have a specific syntax for indexing into a JSON array: SQLite has the ->> operator, while with SQL Server we should be able to use CROSS APPLY with OPENJSON.