Tracking: SQL-backend based meta store

[yezizp2012]

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

• [x] #12475
• [x] Catalog controller(database, schema, table, source, sink, index, view, function, connection, user etc).
• [x] #12690
• [x] SQL-based leader election.
• [x] Refactoring on streaming/barrier manager.
• [x] System parameter, notification version and tracking id etc.
• [x] streaming DDL syntax support
  • [x] create streaming jobs: table, mv, sink, index.
  • [x] drop streaming jobs.
  • [x] cancel streaming jobs.
  • [x] replace table.
  • [x] create sink into table.
  • [x] scaling: reschedule and auto scaling.
• [x] Hummock metadata controller.
• [x] Testing.
• [x] Migration tool from etcd to sql-backend.
• [x] https://github.com/risingwavelabs/risingwave/issues/15030
• [x] #15051
• [x] #15693

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[kwannoel]

• Is background ddl supported?

And for testing to be precise we have:

• [x] Recovery tests
• [ ] Backwards compat tests