"""Mirror of public.normalize_reference_number(text) in Postgres.""" def normalize_reference(value: str | None) -> str | None: """Strip leading whitespace, then remove a single leading lowercase 'a'.""" if value is None: return None v = value.strip() if not v: return None normalized = v[1:] if v.startswith("a") else v return normalized if normalized else None