Don’t you just treat the range as half-open? Eg a '[)' range in Postgres.