Reproducing with_column functionality in SQL

[jaychia]

Describe the bug

I would like to express df = df.with_column("x", df["A"] + 1) in SQL

I am not able to make this work for 2 reasons:

To Reproduce

            df = daft.from_pydict({
                "A": [1, 2, 3, 4],
                "B": [1.5, 2.5, 3.5, 4.5],
                "C": [True, True, False, False],
                "D": [None, None, None, None],
            })

           daft.sql("SELECT *, (A + 1) AS try_this FROM df").show(5)

Expected behavior

No response

Component(s)

SQL

Additional context

No response