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 tenant_id = %(tenant_id)s
                    AND projects.deleted_at ISNULL;""",
                {"tenant_id": tenant_id, "provider": integration})
        )
        r = cur.fetchall()
    return helper.list_to_camel_case(r, flatten=True