def sqltojson(query,param): from django.utils import simplejson from django.db import connection cursor = connection.cursor() cursor.execute(query,param) fieldnames = [name[0] for name in cursor.description] result = [] for row in cursor.fetchall(): rowset = [] for field in zip(fieldnames, row): rowset.append(field) result.append(dict(rowset)) return simplejson.dumps(result)