Case Sensitive Searches
Would like to be able to enable case-sensitive searching. JSON field names in SQL are case sensitive.
example: JSON_VALUE(MyJsonColumn, '$.caseSensitiveFieldName')
Sometimes not everyone on the team is on the same page during development, and half the team uses "CaseSensitiveFieldName" and the other half uses "caseSensitiveFieldName". Eventually we realize the disconnect and have to go back and standardize things. So a case sensitive search would really help.
1
vote
Tyler Brown
shared this idea