SQL Server 2025

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;

(No column name)

Microsoft SQL Server 2025 (RTM-CU7) (KB5096981) - 17.0.4065.4 (X64) 
	Jul  8 2026 23:26:08 
	Copyright (C) 2025 Microsoft Corporation
	Express Edition (64-bit) on Linux (Ubuntu 22.04.5 LTS) <X64>

-- the native JSON type arrived in SQL Server 2025
create table doc (id int, body json);
insert into doc values (1,'{"name":"ann","tags":["sql"]}')
                     , (2,'{"name":"bob","tags":["graph"]}');

2 rows affected

select id, json_value(body,'$.name') as name from doc order by id;

id
name

1
ann

2
bob

-- so did the VECTOR type and regular-expression functions
select cast(cast('[1,2,3]' as vector(3)) as varchar(50)) as vec
     , iif(regexp_like('abc123','^[a-z]+[0-9]+$'), 'matches', 'no match') as pattern;

vec
pattern

[1.0000000e+000,2.0000000e+000,3.0000000e+000]
matches