def METHOD_NAME(name: str) -> db.Project:
    company_id = ctx.company_id
    if company_id is None:
        company_id = null()
    project_record = (
        db.session.query(db.Project)
        .filter(
            (func.lower(db.Project.name) == name)
            & (db.Project.company_id == company_id)
            & (db.Project.deleted_at == null())
        ).first()
    )
    return project_record