how to generate json results using create_sql_agent

[ronald888]

While learning to use create_sql_agent (in Python), I noticed a version of this in Javascript (createSqlAgent).
In the Javascript version, in its intermediate steps (for query-sql tool), the observation field contains data like this...

"observation": "[{\"EmployeeID\":1,\"LastName\":\"Davolio\",\"FirstName\":\"Nancy\",\"Title\":\"Sales Representative\",\"TitleOfCourtesy\":\"Ms.\",\"BirthDate\":\"1968-12-08\",\"HireDate\":\"2012-05-01\",\"Address\":\"507 - 20th Ave. E.Apt. 2A\",\"City\":\"Seattle\",\"Region\":\"North America\"...

The results contain the column names with their values.

In the Python version, in the intermediate steps (for query_sql_db), the output data looks like this...

[(1, 'Davolio', 'Nancy', 'Sales Representative', 'Ms.', '1968-12-08', '2012-05-01', '507 - 20th Ave. E.Apt. 2A', 'Seattle', 'North America'...

Is there a way to reproduce the Javascript results (JSON output) in Python?

Thanks