feat(sql): allow open absolute sqlite path

[thewh1teagle]

This PR updates the sql plugin in plugins-workspace for v2. It now allows opening SQLite files from any absolute path. If the path is not absolute, it still defaults to opening files relative to the app directory.

Examples of possible connection strings:

sqlite:/absolute/path/to/file.db

sqlite:relative_to_app_dir.db

[FabianLars]

As mentioned in https://github.com/tauri-apps/plugins-workspace/pull/1441#issuecomment-2173723910 i plan to make some larger changes and the connection logic will be part of it. Are you okay with me creating a combined PR and add you as a co-author? (github should attribute you basically the same as if it's your pr)

[thewh1teagle]

@FabianLars Sure 👍

[Eveeifyeve]

As mentioned in #1441 (comment) i plan to make some larger changes and the connection logic will be part of it. Are you okay with me creating a combined PR and add you as a co-author? (github should attribute you basically the same as if it's your pr)

any progress on this combined pr? if not i will take it into my own hands.