sql-builder

sql-builder copied to clipboard

Does it support subquery and table alias?

2

Does it support sub query and table alias? ``` select f.col1 A, f.col2 B, s.colx C from foo f, ( select colx from bar where colx=123) s where f.colx=s.colx ```

sekarpdkt

Sample code errors

1

Very good package. There are some errors in the sample code. .where(column("score") > 60 and (column("age") >= 20 or column("address").is_not_null())) "and" should be &&, and "or" should be "||".

jmin911

yang-zzhong

builder.Equal("site_id", "?"),

1

可以支持占位符吗

AmdRyZen

I suggest defining a Join class with table name and ON criteria and adding a std::vector to the classes that support joins.

SpareSimian

https://www.w3schools.com/sql/sql_select_into.asp Unlike INSERT INTO, this creates a new table.

SpareSimian

KondratovRoman

Extensions such as pgroonga have operators such as &@. Adding support for custom operators would be a nice improvement.

EazyAhmed