Issue Description

While using model.bulkCreate, as we pass the options, an object which contains transaction, it comes modified after the execution

What are you doing?

We have called bulk

For #7283 I need to call a different overload of DbConnection.Open in the SQL Server provider. I'm adding a template method to allow this, but similar template methods could be useful in other providers. Tentative list of relevant methods based on what RelationalCommand calls:

• BeginTransaction
• Close
• EnlistTransaction
• State
• Dispose

We could also consider doing this for other Db

Given that we support CURRENT_TIMESTAMP, the lack of CURRENT_DATE feels like an omission. While you can hack it with date(now), I keep finding myself wishing there was a direct way to reference this. Given that now means CURRENT_TIMESTAMP, I think there's precedent for today meaning CURRENT_DATE. This is supported by all backends we support (and is in the ISO standard I believe).

Problem

There are some servers like fastify that allow to define json schemas in order to provide better performance and input / output data validation. Right now I am using prisma with fastify and have to manually define such schemas. Most of these, however, would

go-pg doesn't follow any fixed constraint name conventions.

type TestAccess struct {
	Id        string   `pg:"type:uuid,default:uuid_generate_v4()" json:"id"`
	BatchId   string   `pg:"type:uuid,on_delete:CASCADE,unique:batch_id_test_id" json:"batch_id,omitempty"`
	Batch     *Batch   `json:"batch,omitempty"`
	StudentId string   `pg:"type:uuid,on_delete:CASCADE" json:"student_id,omitempt

what is prefer way to add relation and remove relation? I found example as below, but I did't find any document about the two methods.

 case 'ADD_AUTHOR_TO_BOOK':
        Book.withId(action.payload.bookId).authors.add(action.payload.author);  // add new entity ,  add relation?  this doesn't work.
        break;
    case 'REMOVE_AUTHOR_FROM_BOOK':
        Book.withId(action.payload.bo