请问HN：你们是如何测试MyBatis动态SQL查询的？
（完全披露：我正在开发这个插件，并在AI助手的帮助下撰写这篇文章。这是一次开眼界的实验，展示了AI如何比以往更快地帮助“解决问题”。）
我目前正在一个使用MyBatis的项目中工作，其中一个最大的难点是验证动态SQL。每当我有一个复杂的查询，包含<foreach>、<if>或OGNL表达式时，反馈循环都非常缓慢。
我目前的“工作流程”（我觉得非常繁琐）是：
1. 从XML映射器中复制原始SQL。
2. 手动去除XML标签，如<if test="...">和<where>。
3. 将所有#{param}占位符逐一替换为实际值。（或:param）
4. 最后，将清理后的SQL粘贴到IDE的数据库控制台中，看看它是否能够运行。
我很惊讶地发现，尽管存在许多MyBatis插件，但似乎没有一个在IDE中提供“带参数的直接执行”功能。我本以为这应该是一个标准功能，但感觉我们仍然被查询验证的手动劳动所困扰。
为了解决这个问题，我正在构建一个IntelliJ插件：
- 自动检测SQL（XML或注解）中的参数。
- 提示输入值并即时评估所有动态标签/OGNL。
- 通过IDE内置的数据库工具直接执行最终的原生SQL。
我很想听听HN社区的看法：
1. 如果我发布这样一个工具，你觉得它在你的日常工作中会有用吗？我想了解是否还有其他人也有这种特定的烦恼。
2. 你目前是如何在复杂的MyBatis查询投入生产之前进行验证的？
3. 有没有什么特定的边缘案例或原因让你认为这种“直接执行”功能尚未得到广泛实施？
我期待听到你的想法和建议。非常感谢你的反馈！
查看原文
(Full Disclosure: I am developing this plugin and drafting this post with the assistance of AI agents. It’s been an eye-opening experiment in how AI can help "scratch an itch" faster than ever.)<p>I’m currently working on a project using MyBatis, and one of the biggest friction points for me is verifying dynamic SQL. Whenever I have a complex query with <foreach>, <if>, or OGNL expressions, the feedback loop is painfully slow.<p>My current "workflow" (which I find incredibly tedious) is:
1. Copy the raw SQL from the XML mapper.
2. Manually scrub the XML tags like <if test="..."> and <where>.
3. Replace all #{param} placeholders with actual values, one by one. (or :param)
4. Finally, paste the cleaned-up SQL into the IDE’s database console to see if it even runs.<p>I was surprised to find that, despite many MyBatis plugins existing, none of them seem to offer a "direct execution with parameters" feature within the IDE. I expected this to be a standard feature by now, but it feels like we’re still stuck with manual labor for query verification.<p>To solve this, I’m building an IntelliJ plugin () that:
- Automatically detects parameters in your SQL (XML or Annotations).
- Prompts for values and evaluates all dynamic tags/OGNL on the fly.
- Executes the final native SQL directly via the IDE’s built-in database tools.<p>I’m curious to hear from the HN community:
1. If I were to release a tool like this, would it be something you’d actually find useful in your daily work? I'm trying to gauge if others share this specific frustration.
2. How do you currently verify your complex MyBatis queries before they hit production?
3. Are there any specific edge cases or reasons why you think this kind of "direct execution" hasn't been widely implemented yet?<p>I'm eager to hear your thoughts and suggestions. Many thanks for your feedback!