How to specify dialects related on RDBMS? about squirrel HOT 5 CLOSED

I thought postgresql did support ?, but I see now that its just (?) ODBC that handles that. I have a pretty good idea how to do this.

from squirrel.

This has ended up being a bit more complicated than I originally thought. I'm leaning towards using $? as a sort of pseudo-placeholder to be replaced with $1, $2, etc., along with an explicit PlaceholderFormat setting. Any other suggestions?

from squirrel.

It still needs tests and docs, but the above commit should work like:

sqrl := squirrel.StatementBuilder.PlaceholderFormat(Dollar)
sqrl.Select("*").From("table").Where("x = $?", 5).Where(Eq{"y": 6})

SELECT * FROM table WHERE x = $1 AND y = $2

from squirrel.

In my opinion it would be better if the placeholder is always just a '?'. That would mean i could do something like:

sqrl := squirrel.StatementBuilder
sqrl.Select("*").From("table").Where("x = ?", 5).Where(Eq{"y": 6})

if db == mysql {
    sql, args, err := sqrl.ToSql().PlaceholderFormat(?)
} else if db == postgres {
    sql, args, err := sqrl.ToSql().PlaceholderFormat(Dollar)
}

from squirrel.

@arpemedia I considered that; the tradeoff is that you would be unable to use a literal "?" in your sql. Might be worth it in the name of standardization I guess.

from squirrel.