Open
Description
The Connection and Cursor classes can be moved into the C++ layer to manage states such as handle allocation more effectively. This shift will allow us to encapsulate state management within the C++ layer, reducing complexity and potential bugs in the Python layer. The Python classes will serve as thin wrappers around the C++ implementations, providing a clean and intuitive interface for users.
This will fundamentally help in:
Faster execution with reduced Python overhead
Efficient resource allocation and handle management
Cleaner Python API with thin wrappers and high-performance C++ backend