If I understand you correctly, I would just do this:
1. Use 3 different columns for the value -- each a native data type.
2. Use `coalesce` to handle sorting
3. When displaying in sqlalchemy, just use a property to proxy displaying
the set column (and explicitly work with the correct columns
Hi Jonathan,
Yes, but as I mentioned in the original post, this is to improve an
existing system and a solution that does not involve changes to the
database schema would be ideal.
I think I've found a way forward by adding a column with column_property
and then using a synonym to with a