Mishandling of date-like columns in SQLite results in NaN.

[igalklebanov]

Hey 👋

Handling of date-like columns in SQLite is currently broken.

Affinity is correctly calculated based on the documented heuristics - numeric. But once you input a value similar to the date values in the column, Studio tries to coerce it to number and this results in NaN.

We need to investigate what other products do for such columns and align OR one up them if possible.

[sorenbs]

Hey @igalklebanov 👋 Fixed in #1550. Date-like declared types (datetime, date, timestamp, time) keep their truthful NUMERIC affinity but now edit as text, and the numeric coercion path only converts input that actually parses as a number — non-numeric text passes through, matching SQLite's own NUMERIC-affinity semantics. Studio can no longer write NaN. Displaying the declared type alongside the affinity remains #1386's scope.