Single choice field

Pick one value from a fixed list. Stored as the value string (not an enum id) so the column stays readable in DB queries.

Configuration

Options: ordered list of values + display labels. The first option is the default unless you override.
Default value: which option pre-fills on a new record.
Allow blank: whether a record can have no value (NULL).
Per-option colour: visual badge in the list view (renders as a coloured pill, automatically picks a readable text colour for the background).
Conditional visibility per option: hide certain options based on other field values. Example: hide the "Churned" status option for records where Account Manager is empty.

Either a <select> (default) or a row of clickable pill buttons if you set the form variant to "buttons".

As a coloured pill if per-option colours are set; otherwise the raw value as text.

:, !=, in [...], is null, is not null.