SQLParser

laktory.SQLParser()

SQL Parser translating SQL string expression to a Narwhals Expression.

METHOD	DESCRIPTION
parse	Parse SQL expression.

Source code in laktory/sqlparser.py

def __init__(self):
    self.context = {}

parse(sql)

Parse SQL expression.

PARAMETER	DESCRIPTION
sql	SQL Expression TYPE: str

RETURNS	DESCRIPTION
Expr	Narwhals expression

Examples:

import laktory as lk

parser = lk.SQLParser()

print(parser.parse("2*x + y"))
# > lit(value=2, dtype=None).__mul__(col(x)).__add__(col(y))

Source code in laktory/sqlparser.py

def parse(self, sql: str) -> nw.Expr:
    """
    Parse SQL expression.

    Parameters
    ----------
    sql:
        SQL Expression

    Returns
    -------
    :
        Narwhals expression

    Examples
    --------
    ```py
    import laktory as lk

    parser = lk.SQLParser()

    print(parser.parse("2*x + y"))
    # > lit(value=2, dtype=None).__mul__(col(x)).__add__(col(y))
    ```
    """
    parsed_expr = sqlglot.parse_one(sql)
    # visitor = SQLExprVisitor(self.context)
    return self.visit_expr(parsed_expr)