Wvlet Syntax Highlighting - CDN Test

This page tests the Wvlet language syntax highlighting using the CDN-hosted package from npm.

Package: @wvlet/highlightjs-wvlet

-- Basic model definition
model User = 
  from 'users.json'
  select name, age, email
  where age > 18

-- Using the model
from User
where name like 'John%'
order by age desc
limit 10

model Sales(year: Int) =
  from 's3://bucket/sales/year=${year}/*.parquet'
  select 
    product_id,
    sum(quantity) as total_quantity,
    avg(price) as avg_price,
    count(*) as transaction_count
  group by product_id
  having total_quantity > 100

-- Join with another model
from Sales(2024) s
join Product p on s.product_id = p.id
select 
  p.name,
  s.total_quantity,
  s.avg_price * s.total_quantity as revenue
order by revenue desc

model Report = 
  from Orders
  select 
    customer_id,
    "${order_date}" as date,
    price * quantity as total,
    case 
      when total >= 1000 then 'Premium'
      when total >= 500 then 'Standard'
      else 'Basic'
    end as tier
  where status != 'cancelled' and price > 0

-- Test data quality
test "User data validation" should {
  from User
  test _.size should be > 0
  test _.columns should contain 'email'
  test _.where(age < 0).size should be 0
}