Support subquery in FROM operator about squirrel HOT 9 CLOSED

I also expected Where and Join to accept subqueries. E.g.:

sqlBuilder.
  Select("id").
  From("documents").
  Where(squirrel.Eq("id": sqlBuilder.
    Select("source_id").
    From("refs").
    Where(squirrel.Eq{"target_id", ids})))

This issue hasn't received any love since 2014. Seems Squirrel doesn't have much activity.

from squirrel.

If you use squirrel and postgres, you probably have something like this

var psql = sq.StatementBuilder.PlaceholderFormat(sq.Dollar)

in your code.

Don't use that when writing code which uses subqueries. Instead, simply use squirrel directly.

query := sq.Select()....

Then, just before calling .ToSql(), convert the placeholders:

sql, args, err := query.PlaceholderFormat(sq.Dollar).ToSql()

from squirrel.

Any fix for SelectFrom since this was closed? I am having problems passing arguments using select from and postgres. I keep getting pq: got 1 parameters but the statement requires 0. Workarounds would be satisfactory as well. Thanks!

from squirrel.

This main problem with this and #20 is handling Postgres placeholders. Postgres needs to have unique placeholders (e.g. $1, $2, $3), which is difficult to achieve when combining multiple queries in the current code.

from squirrel.

In my view, It works well with change timing PlaceholderFormat.Placeholders() in selectData.ToSql().
Can I write prototype?

from squirrel.

Go for it. If it works I'll be happy to accept.

from squirrel.

I tried fix this issue on fffd5d6.
I changed SelectBuilder.From() to acceptable SelectBuilder type.

thanks!

from squirrel.

Hi guys! You can also check alternative with no additional builders implementation ;)
https://github.com/elgris/sqrl
If it looks good, I can prepare PR for squirrel.

from squirrel.

AFAIK this is supported with SelectFrom which does not support parameters correctly

from squirrel.