[Refactor/Chore] use sqlite3 to do sql test
- Dominant language
- TypeScript
- Stars
- 156k
- Forks
- 24.6k
- Avg merge
- 22h 9m
- Merged PRs (30d)
- 610
Description
### Self Checks
- [x] I have read the [Contributing Guide](https://github.com/langgenius/dify/blob/main/CONTRIBUTING.md) and [Language Policy](https://github.com/langgenius/dify/issues/1542).
- [x] This is only for refactors or chores; if you would like to ask a question, please head to [Discussions](https://github.com/langgenius/dify/discussions/categories/general).
- [x] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones.
- [x] I confirm that I am using English to submit this report, otherwise it will be closed.
- [x] 【中文用户 & Non English User】请使用英语提交,否则会被关闭 :)
- [x] Please do not modify this template :) and fill in all the required fields.
### Description
now it's hard to do SQL improvement since all the query is patch.
https://github.com/langgenius/dify/pull/38159
or
Testcontainers will be much easier.
### Motivation
Improve DX
### Additional Context
Chat with llm https://g.co/gemini/share/abe5288b661a (chat is in Chinese).
Contributor guide
Assessment
This issue has not been assessed yet.