[Feature request] Separate favorite_queries into a separate config file (or add an "include" keyword feature)

[mbrouillet]

Working as a team, we compile a repository of usefull favorite_queries.
Since we have different .myclirc, this implies merging from one-another's improvements.
It would be ideal if .myclirc would recognize some include otherFile statement, or bash-alike source file. That way, we all include a synced version of our precious favorite_queries section.
Alternatively, but more limited, mycli could scan for the existence of a specifically named file, like .mycli_favorites.
Any other smart solution ?

[rolandwalker]

Hi! This is a great idea, and I've been thinking about it for weeks.

The main barrier is that mycli writes the favorite queries back to the myclirc file. If we use an include file, how will it know which file to write back to?

With the naive solution, favorite queries would be duplicated. With more clever solutions, we might be introducing a breaking change.

However, with the new direction of #1229 , there could be more and more reasons to share/include configuration files.

Maybe it is time to consider a breaking change which also introduces a TOML format configuration file.