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"))
'''
Narwhals Expr
metadata: ExprMetadata(
  expansion_kind: ExpansionKind.SINGLE,
  last_node: ExprKind.NARY,
  has_windows: False,
  n_orderable_ops: 0,
  is_elementwise: False,
  preserves_length: True,
  is_scalar_like: False,
  is_literal: False,
)
'''

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"))
    '''
    Narwhals Expr
    metadata: ExprMetadata(
      expansion_kind: ExpansionKind.SINGLE,
      last_node: ExprKind.NARY,
      has_windows: False,
      n_orderable_ops: 0,
      is_elementwise: False,
      preserves_length: True,
      is_scalar_like: False,
      is_literal: False,
    )
    '''
    ```
    """
    parsed_expr = sqlglot.parse_one(sql)
    # visitor = SQLExprVisitor(self.context)
    return self.visit_expr(parsed_expr)