def companies(request): query_string = request.GET['q'] query = ''.join([ "SELECT equilar_id, company FROM companies WHERE lower(company) LIKE '%", query_string.lower(), "%' LIMIT 10;" ]) rows = Db.execute(query) my_id = lambda x: ' - '.join([x[1], str(x[0])]) f = lambda x: {'id': my_id(x), 'text': x[1]} dicts = map(f, rows) + [{'text': 'Company Not Found', 'id': -1}] return JsonResponse({'items': dicts})