How to add a dynamic ASC DSC Clause

[quillwithones]

Sql.indentifier or sql.litral is not working to add a sql clause

Is that any alternative without doing like this

    query = None
    if order_by == "desc":
        query = sql.SQL(
            """
                SELECT 
                m.id,m.f_name,m.l_name,m.email,m.dial_code,m.phone,m.address,m.created_at as created_at,
                om.role,om.is_approved
                FROM member_org om
                LEFT JOIN "member" m ON om.member_id = m.id
                WHERE om.org_id = {org_id}
                AND m.deleted_at IS null
                ORDER BY {sort_by} DESC
                OFFSET {offset}
                LIMIT {page_size}
            """
        ).format(
            org_id=sql.Literal(org_id),
            offset=sql.Literal(offset),
            page_size=sql.Literal(page_size),
            sort_by=sql.Identifier(sort_by),
        )
    if order_by == "asc":
        query = sql.SQL(
            """
                SELECT 
                m.id,m.f_name,m.l_name,m.email,m.dial_code,m.phone,m.address,m.created_at as created_at,
                om.role,om.is_approved
                FROM member_org om
                LEFT JOIN "member" m ON om.member_id = m.id
                WHERE om.org_id = {org_id}
                AND m.deleted_at IS null
                ORDER BY {sort_by} ASC
                OFFSET {offset}
                LIMIT {page_size}
            """
        ).format(
            org_id=sql.Literal(org_id),
            offset=sql.Literal(offset),
            page_size=sql.Literal(page_size),
            sort_by=sql.Identifier(sort_by),
        )

[dvarrazzo]

you can use sql.SQL("ASC") or sql.SQL("DESC"):

        # order_by being "asc" or "desc"
        query = sql.SQL(
            """
                SELECT 
                ...
                ORDER BY {sort_by} {direction}
            """
        ).format(
            sort_by=sql.Identifier(sort_by),
            direction=sql.SQL(order_by)
        )