What is a good way to specify string column and table names?

[cemremengu]

I would like to create statements where user can specify column and table names. What is good way to do this? Something like:

SELECT(Node.AllColumns, "schema.user_column").FROM("schema.sometable")

[go-jet]

Hi @cemremengu,

You can specify single column, the same way as the list of columns:

SELECT(
    Node.AllColumns,
    Node.SingleColumn,
).FROM(
    Node,
)

Check the wiki.

[cemremengu]

Sorry I worded my question wrong. I actually want to specify a column(s) as a string or list of strings.

[go-jet]

Aha, I see. You can use column and table constructors:

SELECT(
    Node.AllColumns,
    StringColumn("sometable.user_column"), // or IntegerColumn, FloatColumn, ...
).FROM(
    NewTable("schema", "sometable", ""),
)

[go-jet]

Or raw expressions - https://github.com/go-jet/jet/wiki/Expressions#raw-expression

SELECT(
    Node.AllColumns,
    Raw("sometable.user_column"), // or RawInt, RawString, ....
)