Option to Segregate Read and Write queries to have separate db users with each type of query. about sqlc HOT 4 OPEN

suggestion for slight improvement:

type ReadQueries struct {
	...
	selectTable  *sql.Stmt
}

type Queries struct {
	...
	selectTable  *sql.Stmt
	insertTable  *sql.Stmt
}

this would maintain backwards compatibility and can be treated as an optional flag in the config to generate read-only queries

from sqlc.

@kyleconroy , we currently thought of doing what you suggested , but It is resulting in lot of code duplication in terms of models that we being generated.

from sqlc.

It's an interesting idea. We've kicked around generating different interfaces for reader and writers, but that wouldn't solve your issue as you're preparing the queries before hand. The best I can offer right now is moving the read-only queries into a separate query file and create two different packages.

from sqlc.

@kyleconroy can we merge PR #3291 to support this?

from sqlc.