🧠 What It Means

Instead of writing raw SQL by hand, JCB lets you build queries visually. Behind the scenes, JCB automatically compiles your configuration into:

• Joomla’s DatabaseQuery methods (e.g. $query->select()->from()->join()->where())
• Native model logic using Joomla's Database API
• Secure, optimized code compatible with Joomla 3, 4, and 5

This output lives inside your compiled model classes, giving you reliable Joomla-native performance with zero custom SQL.

🎯 Why It Matters

• ✅ Security
  Avoids SQL injection by using Joomla's API (prepared statements by default)
• ✅ Maintainability
  Your queries are model-safe and update-proof through Joomla versions
• ✅ DRY Principle
  Centralize query logic with reusable GETs while avoiding code duplication
• ✅ Performance
  Fine-tuned query logic results in faster, more efficient frontend and backend views
• ✅ Round-Trip Safe
  Since JCB owns the logic, re-compiling won’t destroy or overwrite query structure — it can always be tweaked safely in the GUI

📌 Use Cases

• Backend reports using advanced joins
• Public views fetching filtered datasets
• AJAX calls returning lightweight joined records
• Admin dashboards loading multiple tables efficiently

🧪 Pro Tip

You can inspect the generated Joomla model files after compiling to see exactly how JCB translated your GET visually into code — making debugging and optimization easy.

🔁 Related Features

• Dynamic GET Builder
• Multiple GETs Per View
• Where/Group/Order Statements
• Switch Between List/Item Modes

🧩 Conclusion

By generating Joomla-native query logic, JCB bridges visual query design with professional-grade output. You maintain control, while Joomla ensures performance and security. Build smarter, scale faster — no raw SQL required.