[bbkane]

You might look into your database's support for JSON columns. Sometimes you can even make indices for expressions on them