Add Bloomberg and RIC conversion for symbols

Is your feature request related to a problem?

Convert a symbol to Blomberg and RIC symbologies.

SELECT to_bbg('GIB.A')
>>> 'GIB/A'

SELECT to_ric('GIB.A')
>>> 'GIBa'

One limitation would be for equity derivatives (convertibles, preferreds, options) and crypto pairs like BTC-ETH (BBG -> 'XETXBT') or ETH-USD (BBG -> 'XETUSD') which are rather tricky to convert.

Describe the solution you'd like.

BloombergConverterFunctionFactory and RicConverterFunctionFactory would need to be implemented. I can submit a PR.

Describe alternatives you've considered.

Conversion can also be handled downstream by users but it would be neat to be handled by QuestDB directly. This is usually achieved using regex.

Full Name:

Alexandre Brilhante

Affiliation:

BMO Capital Markets

Additional context

No response