The comment behavior for SQL functions differently in code repositories (SQL Repos) vs Dataset View/Monocle:
note - all data below is notional
Code Repositories (SQL Repo)
In Code Repositories, a comment-toggled multi line comment block will allow the code inside the comment to execute (this is expected behavior and functions similar to SSMS)
select * from `...`
/*
where group = 'A'
*/
-- ^ shows all results with no group filter
select * from `...`
--/*
where group = 'A'
*/
-- ^ shows all results with no group filter
select * from `...`
--/*
where group = 'A'
--*/
-- ^ shows only results with group filter applied
Dataset Preview: SQL Preview or Data Lineage’s SQL Scratchpad
In either the dataset preview or data lineage (it functions the same in both locations), the SQL Commenting behavior functions differently, and is inconsistent with code highlighting.
Here, a comment-toggled multi line comment block does apply the comment block and does not apply the filter to the query. Though, misleadingly, the code highlighting makes it seem as if the where clause is applied.
Here, all of those examples function the same way:
select * from `...`
/*
where group = 'A'
*/
-- ^ shows all results with no group filter
select * from `...`
--/*
where group = 'A'
*/
-- ^ shows all results with no group filter
select * from `...`
--/*
where group = 'A'
--*/
-- ^ shows all results with no group filter
Summary
It seems like Code repositories is functioning appropriately but the behavior in monocle/dataset preview should be adjusted - or at a minimum, the code highlighting should be changed to appropriately reflect the code being executed.