Absolutize and canonicalize runtime config paths

[rylev]

In #1503 we are now ensuring that paths are expanded in expected ways (e.g., environment variable interpolation and ~ expansion). We should be doing the same thing for paths in the runtime config files (e.g., key-value database and SQLite database paths).

We'll likely want some sort of utility function that can do this in a consistent way.