relops / sqlc Goto Github PK

Right now the MySQl generator assumes that the target schema is called sqlc, which only works for the integration tests. We should probably factor this out by introducing command line options for the MySQL DSN.

it'd be really nice to be able to automatically produce syntax RETURNING id. i can hack around it with other methods for now.

I think the API would be nicer if you start with the db. I.e. db.Select(...).From(...).Query(). It also avoids having to specify the dialect each time.

I attempted to do this on my fork (see alokmenghrajani@f441c53), but I'm not sure if you care about keeping the API backwards compatible.

Currently, to cast a field to a given type, you need to supply the string representation of the underlying SQL type. This is neither type safe nor portable. We should introduce a strongly typed representation that can be adjusted for target dialects.