From python classes/tokens to sql

[chriskathumbi]

Hello, I'd like to find out if it's possible to start with tokens and build a query from that. I'd like to use this for simple api.
Where I can define the sql tokens as classes, like this:

from dataclasses import dataclass
from enum import StrEnum
from typing import Literal, Union


class DataType(StrEnum):
    INT = "int"
    FLOAT = "float"
    STRING = "string"
    TEXT = "text"
    BOOL = "bool"


@dataclass
class Column:
    kind: Literal["column"] = "column"
    table_name: str
    column_name: str
    data_type: DataType

    def __str__(self):
        return f"{self.table_name}.{self.column_name}"


@dataclass
class LitValue:
    value: str
    data_type: DataType

    def __str__(self):
        if self.data_type in ("string", "text"):
            return f"'{self.value}'"
        return f"{self.value}"


@dataclass
class Expr:
    kind: Literal["expr"]
    operator: Literal["=", "!=", ">", "<"]
    left: Union[Column, LitValue, "Expr"]
    right: Union[Column, LitValue, "Expr"]
    negate: bool = False
    include_nulls: bool = False

    def __str__(self) -> str:
        expr = f"{self.left} {self.operator} {self.right}"
        if self.include_nulls:
            expr = f"({expr} or {self.left} is null)"
        if self.negate:
            expr = f"not {expr}"

        return expr


@dataclass
class Rule:
    kind: Literal["rule"] = "rule"
    rule: Expr

    def __str__(self) -> str:
        return f"{self.rule}"


@dataclass
class RuleGroup:
    kind: Literal["group"]
    logical_operator: Literal["and", "or"]
    group: list[Union[Rule, "RuleGroup"]]

    def __str__(self) -> str:
        rules = [str(rule) for rule in self.group]
        expr = "(" + f" {self.logical_operator} ".join(rules) + ")"

        return expr

[georgesittas]

It may be possible but you'll probably have better chances getting feedback on the Slack #random or #sqlglot channel.