Generate VALUES statement from model instance

[AndrewWinterman]

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

I would like to be able to generate a virtual table from an existing model instance, so that I can do a conditional insert in postgres without resorting to postgres.Raw or transaction semantics.

For example, I want to do

INSERT INTO users (name, email, created_at)
  SELECT 'John Doe', 'john@example.com', NOW()
  WHERE NOT EXISTS (
      SELECT 1 FROM users WHERE email = 'john@example.com'
  );

but I want all the fields to be provided by any arbitrary jet model instance

Describe the solution you'd like
A clear and concise description of what you want to happen.

One possible solution would be to simply make func UnwindRowFromModel(columns []Column, data interface{}) []Serializer { public.

[houtn11]

What do you mean by an arbitrary jet model instance?

You can write your query something like this:

stmt := Users.INSERT(Users.Name, Users.Email, Users.CreatedAt).
			QUERY(
				SELECT(
					String("John Doe"),
					String("john@example.com"),
					NOW(),
				).WHERE(
					NOT(EXISTS(
						SELECT(
							Int(1),
						).FROM(
							Users,
						).WHERE(
							Users.Email.EQ(String("john@example.com"))
						)
					))
				)
			)

[AndrewWinterman]

What do you mean by an arbitrary jet model instance?

I mean I don't have a specific model instance

You can write your query something like this:

stmt := Users.INSERT(Users.Name, Users.Email, Users.CreatedAt).
			QUERY(
				SELECT(
					String("John Doe"),
					String("john@example.com"),
					NOW(),
				).WHERE(
					NOT(EXISTS(
						SELECT(
							Int(1),
						).FROM(
							Users,
						).WHERE(
							Users.Email.EQ(String("john@example.com"))
						)
					))
				)
			)

This is close, but I need to do the following:

stmt := Users.INSERT(Users.Name, Users.Email, Users.CreatedAt).
 			QUERY(
 				SELECT(
 					userModelInstance,
 				).WHERE(
 					NOT(EXISTS(
 						SELECT(
 							Int(1),
 						).FROM(
 							Users,
 						).WHERE(
							Users.Email.EQ(String("john@example.com"))
 						)
 					))
 				)
)