{
    ResponseStatus: {
    Message = 'SUCCESS'
    }
}

select * from someDatabase
  where
    JSON_VALUE(ParameterOut, '$.ResponseStatus.Message') = 'SUCCESS'