Optimization: yy_json memory allocation improvement

[acquamarin]

API

C++

Description

Internally, we use the library yy_json to parse json strings.

yy_json uses the system default allocator: malloc to allocate memory if no allocator is provided. However, fragmentation can be easily caused when the number of allocations is large. To resolve this issue, Duckdb implemented their own allocator which allocates memory from their own memoryManager and pass to yy_json.

I suggest we do something similar as duckdb to solve this issue.