Skip to content
DuckDB Extensions All extensions Inflector

Inflection functions in the Inflector DuckDB extension

Function category

Inflection

2 functions

English plural / singular conversion. Handles irregulars (person → people, mouse → mice).

inflector_to_plural

Scalar function Inflection
Signature
inflector_to_plural(word: VARCHAR) → VARCHAR
Arguments (Positional)
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

inflector_to_singular

Scalar function Inflection
Signature
inflector_to_singular(word: VARCHAR) → VARCHAR
Arguments (Positional)
Argument word Type VARCHAR Mode Positional Description
Description

Singularize an English word. The v1.5 source fix 8628623 (extension version 2026100701) adds people → person and children → child, preserving the suffix case and compound prefixes. Older community build ac9b69f leaves those plurals unchanged.

1 Example 1 
SELECT inflector_to_singular('people');

Output

inflector_to_singular('people')
people
Related functions