DuckDB Extensions
Inflection functions in the Inflector DuckDB extension
Function category
Inflection
2 functionsEnglish plural / singular conversion. Handles irregulars (`person` → `people`, `mouse` → `mice`).
Signature
inflector_to_plural(word: VARCHAR) → VARCHAR
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
word
|
Type
VARCHAR
|
Mode Positional | Description |
Description
Pluralize an English word — handles irregulars (person→people, mouse→mice).
1
Pluralize
SELECT inflector_to_plural('person');Related functions
Signature
inflector_to_singular(word: VARCHAR) → VARCHAR
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
word
|
Type
VARCHAR
|
Mode Positional | Description |
Description
Singularize an English word.
1
Example 1
SELECT inflector_to_singular('people');Output
| inflector_to_singular('people') |
|---|
| people |