URL encode username/password in sql_raw

Hi, could we automatically URL-encode the DSN URI in sql_raw component? I think this could be handled transparently by Benthos, the client should not have to take care of that.

Here is my scenario:
I have a secrets manager storing a database password which is shared with other applications and that password is passed to Benthos as an environment variable, which is configured in sql_raw like:

- sql_raw:
    driver: postgres
    dsn: >-
      postgres://${DATABASE_USERNAME}@${DATABASE_HOST}:${DATABASE_PORT}/${DATABASE_NAME}?sslmode=disable&connect_timeout=10&password=${DATABASE_PASSWORD}
    query: |-
      SELECT blalbalba FROM popcorn

Since the field does not support interpolation, the current implementation forces me to have another environment variable like DATABASE_PASSWORD_URL_ENCODED and that is not really good to maintain.

As usual, any alternative ideas are appreciated.

The issue names the sql_raw component and its dsn field; start by locating that component’s DSN handling and inspecting how PostgreSQL connection strings are passed through. Define and test the expected encoding behavior for credentials using the supplied environment-variable example, then verify existing sql_raw behavior remains intact.