phidatahq / phidata

Build AI Assistants with memory, knowledge and tools.
https://docs.phidata.com
Mozilla Public License 2.0
10.45k stars 1.51k forks source link

update-sql-tool-phi-824 #979

Closed ysolanky closed 1 month ago

ysolanky commented 1 month ago

Fixed the run_sql function to address issues with fetchall() and fetchmany() when executing SQL queries that don’t return results, such as CREATE and INSERT statements. Additionally, the dependency on simplejson has been removed and instead just json is used now. The default string conversion in json.dumps has also been added.

Please review and merge this pull request prior to this PR.