SQL Prompt 11

SQL Prompt v11.2 required

SQL Server 2025 Support is only available in SQL Prompt v11.2 onwards. Download the latest version

This document outlines the support provided in SQL Prompt v11.2 for SQL Server 2025, including supported functionality and known limitations.

What Is Supported

We are pleased to announce SQL Prompt support for SQL Server 2025 syntax, including recognition of newly introduced keywords, data types, and functions. More details about supported syntax and usage are available in the official documentation.

List of the newly supported keywords and functions

Artificial intelligence	Regular expressions	Other additions and improvements
VECTOR_DISTANCE	REGEXP_LIKE	SUBSTRING
VECTOR_NORM	REGEXP_REPLACE	DATEADD
VECTOR_NORMALIZE	REGEXP_SUBSTR	UNISTR
VECTORPROPERTY	REGEXP_INSTR	PRODUCT
CREATE VECTOR INDEX	REGEXP_COUNT	CURRENT_DATE
CREATE EXTERNAL MODEL	REGEXP_MATCHES	EDIT_DISTANCE
ALTER EXTERNAL MODEL	REGEXP_SPLIT_TO_TABLE	EDIT_DISTANCE_SIMILARITY
DROP EXTERNAL MODEL		JARO_WINKLER_DISTANCE
AI_GENERATE_CHUNKS		JARO_WINKLER_SIMILARITY
AI_GENERATE_EMBEDDINGS		- BASE64_ENCODE - BASE64_DECODE
		\|\| (String concatenation)

What Is Not Supported

List of the keywords/functions that are currently not supported.

JSON_OBJECTAGG

JSON_ARRAYAGG

JSON_QUERY WITH ARRAY WRAPPER

VECTOR_SEARCH

Vector data type with half-precision float