representation.text.wordSingle word without spaces (alphanumeric or with common separators like hyphen).
$ finetype infer -i "hello"
→ representation.text.wordSELECT finetype('hello');
-- → 'representation.text.word'LOWER(CAST({col} AS VARCHAR))-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'representation.text.word';{
"$id": "https://meridian.online/schemas/representation.text.word",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Single word without spaces (alphanumeric or with common separators like hyphen).",
"examples": [
"hello",
"world",
"hello-world",
"test_123"
],
"maxLength": 100,
"minLength": 1,
"pattern": "^[a-zA-Z0-9]([a-zA-Z0-9\\-_]*[a-zA-Z0-9])?$",
"title": "Single Word",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "LOWER(CAST({col} AS VARCHAR))"
}helloworldhello-worldtest_123