def METHOD_NAME(tenant_id, integration):
    with pg_client.PostgresClient() as cur:
        cur.execute(
            cur.mogrify(
                """SELECT integrations.* 
                    FROM public.integrations INNER JOIN public.projects USING(project_id) 
                    WHERE provider = %(provider)s 
                        AND projects.deleted_at ISNULL;""",
                {"provider": integration})
        )
        r = cur.fetchall()
    return helper.list_to_camel_case(r, flatten=True)