code: def tsql_query(query, **kwargs):
      '''
      Run a SQL query and return query result as list of tuples, or a list of dictionaries if as_dict was passed, or an empty list if no data is available.
  
      CLI Example:
  
      .. code-block:: bash
  
          salt minion mssql.tsql_query 'SELECT @@version as version' as_dict=True
      '''
      try:
          cur = _get_connection(**kwargs).cursor()
          cur.execute(query)
          # Making sure the result is JSON serializable
          return loads(_MssqlEncoder().encode({'resultset': cur.fetchall()}))['resultset']
      except Exception as err:
          # Trying to look like the output of cur.fetchall()
          return (('Could not run the query', ), (six.text_type(err), )f tsql_query(query, **kwargs):
      '''
      Run a SQL query and return query result as list of tuples, or a list of dictionaries if as_dict was passed, or an empty list if no data is available.
  
      CLI Example:
  
      .. code-block:: bash
  
          salt minion mssql.tsql_query 'SELECT @@version as version' as_dict=True
      '''
      try:
          cur = _get_connection(**kwargs).cursor()
          cur.execute(query)
          # Making sure the result is JSON serializable
          return loads(_MssqlEncoder().encode({'resultset': cur.fetchall()}))['resultset']
      except Exception as err:
          # Trying to look like the output of cur.fetchall()
          return (('Could not run the query', ), (six.text_type(err), ))
docs: Run a SQL query and return query result as list of tuples, or a list of dictionaries if as_dict was passed, or an empty list if no data is available.
  
      CLI Example:
  
      .. code-block:: bash
  
          salt minion mssql.tsql_query 'SELECT @@version as version' as_dict=True