Comment by megaman821

I usually use generated columns for this. It still uses CASE WHEN but it is obvious to all consumers of the table that it exists.