Switch the default compilation stack to the new GOpt-based framework in GIE

[BingqingLyu]

Is your feature request related to a problem? Please describe.

We have recently introduced a new GOpt-based compilation stack, which offers robust support for both Cypher and Gremlin query languages. This advanced stack enhances the query processing capabilities with both rule-based and cost-based optimization strategies, ensuring efficient execution across various graph query scenarios.

We are currently planning to switch the default compilation stack from the older, IRCore-based implementation to the new, GOpt-based framework.

[BingqingLyu]

To achieve this goal, there are several tasks that we need to undertake:

1. P1: bug fix

• [BUG] Unexpected Type Inference in PathExpand #3730
• [BUG] Unexpected results when dealing with HEAD in the new compilation stack #3731
• [BUG] Unexpected ExpandE and GetV fusion  #3732
• [BUG] Missing pattern sentences in Pattern Matching in GOpt-based compilation #3774
• [BUG] Unexpected when dealing with filters in match in the GOpt-based compilation #3791
• P2: [BUG] Unexpected alias maintenance in the new GOpt-based compilation stack #3792

2. P1: comprehensive tests

• Tests on ModernGraph, on MovieGraph and LdbcGraph, based on the new GOpt-based compilation.
• P2: Tests on different storages.

3. P2: feature support

compiler:

• P1: Support to fetch properties of each elements in path in GOpt #3940
• coin
• sample
• unfold

runtime (insight):

• P1: nested map
• case when
• comparison of temporal types

e2e:

• edge type defined in a triplet
• P1: path join (concat two sub-paths into one)

[BingqingLyu]

There's still some issue to be addressed.