Using NextMoveSoftware Arthor in SQLAlchemy

arthor_alchemy.py

def get_matching_buildingblocks(
        db: Session,
        smarts: str,
        limit: int,
) -> List[BuildingBlock]:
    r = db.query(BBSelect) \
        .filter(func.arthor.matches(column('atdb'), smarts)) \
        .limit(limit) \
        .all()
    return [
        BBSelection.BBSelect.from_orm(elem)
        for elem in r
    ]