Route specific users to replica

[matteosilv]

Would it be easy to add a user level configuration to route the user only to the read replica?

We have a use case where it's not possible for us to configure correctly the options in the connection string, becuse of the third party system connection.

[levkk]

We have a read_only flag on users that currently only sets default_transaction_read_only to on. We could repurpose that for query routing too:

[[users]]
name = "read_user"
database = "prod"
read_only = true