Bug:

[craig-clifford]

Describe the bug

Describe the bug
The word "OPTIONAL has appeared around elements in the where clause. this cause an error in SQL Server 2012.

To Reproduce
Steps to reproduce the behavior:

1. Go to run query: DELETE TOP (1) FROM Access.CurrentClasses WHERE classkeyid IN (Optional(9028));
2. See error

Expected behavior
I expect the query to make the changes like "delete current row" the run the query

Screenshots

Additional details
It gives the error: Msg 195, Level 15, State 10. 'Optional' is not a recognized built-in function name.

Product

SQLPro Studio

App version

Version 2026.03 (Build 111158.5)

Platform

macOS

Installation source

App Store

[hankinsoft]

Hmm, I'm not able to reproduce this on 2026.03:

Would you possibly be able to provide a DDL and an insert for a table that you are able to reproduce this on? If I can reproduce it, I should be able to sort it out pretty easily.