Tracking: Improve management and observability of creating stream jobs

[kwannoel]

Useful to know whether a job is rate limited, whether it's executing in the background or foreground. What's it's backfilling state.

• Return mv catalog to FE on creating. (Done)
• Return sink catalog to FE on creating.
• Return index catalog to FE on creating.
• Support drop creating MV.
• Support drop creating sink.
• Support drop creating index.
• rw_catalog: provide a check if mv is background_ddl. feat(frontend): allow users to confirm if background_ddl is enabled for a materialized view #19085
• rw_catalog: provide a check if sink is background_ddl.
• rw_catalog: provide a check if index is background_ddl.
• rw_catalog: provide a check for mv's backfill_rate_limit.
• rw_catalog: provide a check for sink's backfill_rate_limit.
• rw_catalog: provide a check for index's backfill_rate_limit.
• rw_catalog: provide a check for source's backfill_rate_limit.
• Make state table visible for creating MV #19031
• Mark whether a stream job was created or creating in rw_materialized_views #19119
• Provide a way to check backfilling rate (in rows/s). #19120