-- Comments and doc comments
---
This is a doc comment
@param id The user identifier
---

-- Single line comment
model user = {
  from 'users.parquet'
}

-- String literals
val message = "Hello, World!"
val multiline = """
  This is a
  multiline string
"""
val path = 'data/input.json'

-- Numbers
val integer = 42
val long = 100L
val decimal = 3.14159
val float = 2.5f
val exponential = 1.23e-4

-- Backquoted identifiers
select `column with spaces`, `reserved-keyword`

-- Query operations
from products
where price > 100.0 and category = 'Electronics'
group by brand
having count(*) > 5
order by total_sales desc
limit 20

-- Column operations
add new_column = price * quantity
exclude temp_column
rename old_name to new_name

-- Set operations
from table1
concat
from table2
dedup

-- Window functions
select
  row_number() over (partition by category order by price desc) as rank

-- Conditional expressions
case
  when status = 'active' then 1
  when status = 'pending' then 0.5
  else 0
end

-- Lambda expressions
transform x => x * 2

-- Test assertions
test output should be """
| id | name    |
|----|---------|
| 1  | Alice   |
"""