oracle comments inside column parenthesis breaks parsing about sqlglot HOT 2 CLOSED

A simpler example:

SELECT id, ( a /*+b*/ + c) sum_cols
FROM my_table

the above query has a comment for +b only and because the comment is /* */ the sequence /*+ breaks the parsing.

from sqlglot.

This is out of scope for us right now. The issue is that hints are tokenized & parsed as if they were not comments:

>>> import sqlglot
>>> sqlglot.parse_one("SELECT /*+ REPARTITION(100) */ x FROM tbl")
Select(
  hint=Hint(
    expressions=[
      Anonymous(
        this=REPARTITION,
        expressions=[
          Literal(this=100, is_string=False)])]),
  expressions=[
    Column(
      this=Identifier(this=x, quoted=False))],
  from=From(
    this=Table(
      this=Identifier(this=tbl, quoted=False))))

The alternative would be to treat hints as comments, but that's brittle because comments are attached on tokens based on heuristics and there may be edge cases where hints are lost because they're attached to the wrong token.

Perhaps you can do a regex substitution in order to include a space between /* and +. This will result in tokenizing this as a comment.

from sqlglot.