async def METHOD_NAME(self, connection: SAConnection, *, node_id: uuid.UUID) -> ProjectNode:
    """get a node in the current project
    NOTE: Do not use this in an asyncio.gather call as this will fail!
    Raises:
        ProjectsNodesNodeNotFound: _description_
    """
    get_stmt = sqlalchemy.select(
        *[c for c in projects_nodes.c if c is not projects_nodes.c.project_uuid]
    ).where(
        (projects_nodes.c.project_uuid == f"{self.project_uuid}")
        & (projects_nodes.c.node_id == f"{node_id}")
    )
    result = await connection.execute(get_stmt)
    assert result  # nosec
    row = await result.first()
    if row is None:
        msg = f"Node with {node_id} not found"
        raise ProjectNodesNodeNotFound(msg)
    assert row  # nosec
    return ProjectNode.from_row(row)