There's a postgres extension called semver that lets you create columns with a semver datatype: https://pgxn.org/dist/semver/
Would love to see this supported in render.
Specifics about my use case:
  • My app is built around data from a tracing client.
  • The tracing client sends a version string with each trace, i.e. the version of the tracing lib.
  • I store traces in a db and would like to filter for stuff like "client version above 0.2.10" but you can't do that with just string comparisons. (This is what the semver extension is for.)