Checking for the nul characters in fields

[aptly-io]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

def check_nul(cls: Any, values: Dict[str, Any]) -> Dict[str, Any]:
    """to prevent hacking, do not allow the NUL character in a str (used by the root_validator)"""
    for val in (values if isinstance(values, dict) else values.model_dump()).values():
        if isinstance(val, str) and "\x00" in val:
            raise ValueError()
    return values


class ListQuery(BaseModel):

    model_config = ConfigDict(extra="forbid")

    _check_nul = model_validator(mode='before')(check_nul)

Description

When the REST API got fuzzy tested by injecting random data, I found that NUL characters (\x00) ended up in the database. Is there a nice way to prevent/check NUL characters in string typed fields?
(python handles the NUL characters okish but it is troublesome for c-based clients).

The Example Code shows how I handle it for the moment. But it is easy to overlook adding this check.

Operating System

Linux

Operating System Details

No response

SQLModel Version

before 0.0.21

Python Version

3.11

Additional Context

No response