Unable to interface with more than one database in a single go program

[Morpheus0x]

Because global variables are shared within the whole go program, it is currently impossible to use sqx with more than one database in a single go program.

I would propose a change or addition to sqx, where the functions sqx.Read and sqx.Write can be called with an additional parameter, passing the *sql.DB database connection directly, without relying on the internal global variable defaultQueryable.

My use case requires that I connect to more than one database. I really enjoy working with sqx and feel that this change greatly improves the usefulness of this library for everyone.

I am going to fork this project and implement this for myself since it seems to be a straightforward change. Please let me know if this is something interesting to be upstreamed to you.

[Morpheus0x]

I overlooked the WithQueryable method, maybe this is all I need. Will test it out.

[max-stytch]

Heya @Morpheus0x - yeah, WithQueryable should do what you need. If you need to call WithQueryable on every DB interaction, try this incantation from the README -

func Read[T any](ctx context.Context, db sqx.Queryable) interface {
	Select(columns ...string) sqx.SelectBuilder[T]
} {
	return sqx.Read[T](ctx).WithQueryable(db).WithLogger(logging.FromContext(ctx))
}

func Write(ctx context.Context, db sqx.Queryable) interface {
	Insert(tblName string) sqx.InsertBuilder
	Update(tblName string) sqx.UpdateBuilder
	Delete(tblName string) sqx.DeleteBuilder
} {
	return sqx.Write(ctx).WithQueryable(db).WithLogger(logging.FromContext(ctx))
}