Concat function is restricted in get_all

ERPNext
1

Hey team,

I’m trying to use concat function in get_all() in .py, but it returns “use is restricted”. Must I use frappe.db.sq() instead?

return frappe.db.get_all(
                doctype,
                filters=current_filters,
                group_by="`tab{0}`.{1}".format(doctype, field),
                fields=[
                    "count(*) as count",
                    "`{}` as name".format(field),
                    "concat(`{first_name}`, ' ', `{last_name}`) as full_name"],
                order_by="count desc",
                limit=50,
            )