Feature Request: Rewrite 'Lock Table' Statements

[earayu]

Background

Currently, WeSQL-Scale does not support 'Lock' and 'Unlock' statements due to their impact on the connection pooling mechanism. Executing these statements in WeSQL-Scale returns "Success" without actually performing the intended action.

Proposal

To address this issue, we need to rewrite the 'Lock' and 'Unlock' statements to ensure proper reuse of connections in the WeSQL-Scale connection pool.