Update type mapping/converters to make translation data available for query generation

[ajcvickers]

From #10265 (comment)

Notes from planning:

• We will add ordering metadata to value conversions, which will then be available on the type mapping
• If conversion is not order-preserving, then we throw if an order-based operation is used.
  • For example less than, greater than, min, max.
  • This could include order-by, but note, that commonly any fixed ordering can fine.
• Add API to allow these operations anyway