leporo / sqlf Goto Github PK

as title

Hello,
I'm trying to generate something similar to the following query with sqlf, but I can't find a correct sqlf syntax:

 SELECT product_name, code FROM en WHERE code IN(SELECT code from en_fts where en_fts MATCH "XXX");

Is there currently a way to achieve such statement, or do I need to split my query in two statements ?

• With(query)
• WithRecursive(query)

Add the SubQuery(prefix, suffix, query) method.

It makes sense to call the Close method for query instance passed in.

Is there no way to use database columns from the structure? To get type-save

Examples in README.md and stmt.go use Returning() with ExecAndClose() but to actually obtain id one should use QueryRowAndClose().

Can you add support for order by with arguments? Maybe OrderByExpr or something

Consider to:

• Split Build method into String (SQL) and Args
• Rename Builder type to SQLf
• Make Dialect unexported