[Refactoring]: Umbrella issue of refactor temporary table

[nnsgmsone]

Why do you want to refactor this code?

memtable need to refactor

Describe the solution you'd like

Cost to maintain memengine is too much. we need to use some light weight memtable to support memtable and general table together, like using cn workspace

This issue is a summary of related task issues:

• [Bug]: desc temp table is empty #10300
• [Bug]: panic happens when load data into the temporary table. #7875
• [Bug]: insert into temporary table shows internal error: panic concurrent mutation: #10834
• [Bug]: Temporary table cannot work with hide pk #9124
• [Bug]: No temporary table record in mo_tables when create a temporary table. #9108
• [Bug]: Temp table: no duplicate key，but report duplicate entry on ci test. #12556
• https://github.com/matrixorigin/MO-Cloud/issues/1515
• [Bug]: Temporary engine not init yet #13415
• [Bug]: Temp Table: Run auto_increment case in pessimistic mode multi times gets different result. #10903

Describe alternatives you've considered

No response

Additional information

No response

[Ariznawlll]

wating for refactor of temporary table：#10903

[ouyuanning]

Temporary table-related bvt cannot be passed under the case of adding a hidden primary key.
bvt run tests/distributed/cases/transaction, all temporary table-related cases will fail.