Add support for native JSON datatype in SQL Server 2025 in Schema Builder

[martijnvt1981]

Laravel's Schema Builder's ->json() method currently creates nvarchar(max) columns for JSON data on SQL Server. However, SQL Server 2025 introduces native JSON datatype support.

I'd like to see support for native JSON datatype in SQL Server 2025 added to Laravel's SQL Server grammar so that ->json() creates JSON columns instead of nvarchar(max). We'd need to introduce backwards compatibility though, as SQL Server 2022 does not support native JSON, but the 2025 version does.

[martijnvt1981]

Carefully mentioning @driesvints & @taylorotwell here 🙂. Hope you don’t mind, but I see a lot of threads here unanswered.