tiangolo / sqlmodel

SQL databases in Python, designed for simplicity, compatibility, and robustness.
https://sqlmodel.tiangolo.com/
MIT License
13.54k stars 611 forks source link

Add type of _TScalar at expression.py.jinja2 #776

Open NapoliN opened 5 months ago

NapoliN commented 5 months ago

Most SQL languages support datetime, date, and time as different data types. Nevertheless, SQLModel's expression.py supports only datetime type. Since you can also use date and other types in model building, you cannot get proper completion when using select() function and so on.

Therefore, I propose to add date and time types from datetime module.