Explains SQL dialect differences
Types, identifier limits, reserved words, indexes and constraint enforcement differ by engine.
Can AI do this?
AI does this well Most of the tested AI models master this. 10 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 100% | Mastered |
| gemini-3.1-pro-preview | Flagship | 100% | Mastered |
| gpt-6-astra | Flagship | 100% | Mastered |
| claude-fable-5-1 | Flagship | 100% | Mastered |
| gemini-3.8-flash | Mid tier | 100% | Mastered |
| gpt-6.1-sol | Mid tier | 100% | Mastered |
| claude-sonnet-5-5 | Mid tier | 100% | Mastered |
| gemini-3.5-flash-lite | Low cost | 100% | Mastered |
| gpt-6-luna | Low cost | 100% | Mastered |
| claude-haiku-5-5 | Low cost | 100% | Mastered |
Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.
What it looks like in practice
Expected result: Types, identifier limits, reserved words, indexes and constraint enforcement differ by engine
How it is assessed: Predicts how sample DDL renders and behaves on each engine
Related knobits
Needed for
- K-717 Recognises a check expression unable to run
- K-806 Recognises a configured dialect left unregenerated
- K-808 Recognises a CHECK constraint parsed and ignored
- K-809 Recognises an expression running on one engine only
- K-810 Recognises a truncated identifier taken as the real name
- K-811 Recognises a reserved word used as an identifier
- K-812 Recognises a type meaning something else on another engine
- K-813 Recognises an index the target engine cannot create or run
All 33 knobits of Generate and review DDL.
Source: Data-management practice used by the stage 8 reference and review checklist