how to get json data from duckdb

[hyxdxhb123]

When I use @duckdb/node-api to read JSON data from a DuckDB database, it returns a string type. How can I make it directly return the JSON type without the need for type conversion?

import {DuckDBInstance} from '@duckdb/node-api';
async function getproductinfo(code) {
    try {
        const instance = await DuckDBInstance.fromCache('test.db');
        const connection = await instance.connect();
        
        // 使用DuckDB的JSON函数在查询时解析JSON字符串
        const reader = await connection.runAndReadAll(
            `SELECT te 
            FROM test 
            WHERE id = 1;`
        );

        //console.log(reader);

        connection.closeSync();
        instance.closeSync();
        const rowObjects = await reader.getRowsJson();
        
        console.log(rowObjects);
        return rowObjects;
    }
    catch (e) {
        console.log(`DuckDB 查询失败: ${e.message}`);
    }
}
(async () => {
    let product = await getproductinfo(1);
    // node.send(msg);
})();

[jraymakers]

DuckDB represents JSON data as strings. The JSON type is really just a VARCHAR, but with a type alias, "JSON".

If you inspect the column type of the result, using columnType(index) or columnTypes(), you can read the alias field of the DuckDBType object. This can be used to distinguish JSON VARCHARs from normal VARCHARs.

JSON values are returned as JS strings; if you want to convert them to JS objects, you'll have to use JSON.parse.

The getRowsJson method converts the returned data, of any type, to JSON-compatible JS object; it doesn't convert from JSON.