QL0070 Unknown Function

A function call is not recognized for the active dialect profile.

When It Appears

• Dialect mode is active and the function name is misspelled, unsupported, or unavailable in the chosen family
• Suggestions and candidates may help if the name is close to a known function

Example

QueryLens.Dialect = DialectProfile.SqlServer2019;
var query = new SqlQuery("SELECT STRNG_AGG(name, ',') FROM dbo.departments");
Assert.Contains(query.Errors, issue => issue.Code == "QL0070");

Next Steps

• Confirm spelling
• Confirm the selected dialect family
• Check whether the real issue is version support instead