@database :memory:
@database :temp:
@database :default:
@database :default-no-rowidalias:
@database path/to/file.db readonly

@skip-file "reason to skip all tests"
@skip-file-if mvcc "reason to skip in MVCC mode"
@skip-file-if sqlite "reason to skip on sqlite backend"
@requires-file trigger "all tests need trigger support"

setup schema {
    CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);
}

@setup schema
@skip "known bug"
@skip-if mvcc "not supported in MVCC"
@skip-if sqlite "sqlite has different behavior"
@backend rust
@requires trigger "needs trigger support"
test my-test {
    SELECT * FROM users;
}
expect {
    1|Alice
}

@setup schema
@backend cli
@requires strict "needs strict tables"
snapshot query-plan {
    SELECT * FROM users WHERE id = 1;
}

expect { ... }           # Exact match
expect error { ... }     # Expect error
expect pattern { ... }   # Regex pattern match
expect unordered { ... } # Set comparison
expect raw { ... }       # Raw output
expect @rust { ... }     # Backend-specific expectation