Insert value generated by SQL func (crypt) and return model

[VRmnv]

I want to insert user with password into database using crypt function for hashing.

INSERT INTO users(login, password) VALUES
	('login', crypt('password', gen_salt('bf')));

How can i do this with bob? I tried code generation but Setters doesn't provide an option to define a value generated by SQL func.
Is generating a query via builder the only way?

[stephenafamo]

Yes, you would have to use the query builder.

models.Users.Insert(
    im.Values(
        psql.Arg("[email protected]"),
        psql.Raw("crypt(?, gen_salt('bf'))", "password"),
    ),
)

[VRmnv]

Thanks!