Is your feature request related to a problem? Please describe. When Using JDBC as backend - the values are always returned as String. We have node JS applications consuming the properties for config server and it is tedious to iterate through values and parse it. We understand the design is based on data type Value DB column which is most likely Varchar.
However we do use Postgres and would like to store value as a JSONB datatype - so it would support string,integer and boolean. {"value":9999} or { "value": true}
Describe the solution you'd like
PropertiesResultSetExtractor is a static class which creates a Map
with PG as backend, SELECT key,json_value -> 'value' from test where application=? and profile=? and label=?
Describe alternatives you've considered We tried to handle this with below JACKSON settings to false, however it does not work spring.jackson.mapper.allow-coercion-of-scalars=false
Additional context Add any other context or screenshots about the feature request here.