DoSQL is a third-party plugin developed by myFMButler that simplifies complex FileMaker queries by allowing you to execute full CRUD (Create, Read, Update, Delete) and Data Definition operations directly within FileMaker calculations and scripts.
While FileMaker’s native ExecuteSQL() function is strictly limited to SELECT (read-only) statements, DoSQL bypasses this limitation, reducing the need for elaborate relationship graphs, multi-step scripts, and auxiliary layout switching. Key Ways DoSQL Simplifies Queries
Eliminates Script Steps for Data Modification: Instead of switching layouts, entering find mode, creating a record, and setting fields, DoSQL allows you to write a clean INSERT or UPDATE statement in a single calculation.
Bypasses the Relationship Graph: You can query, update, or delete data from any table occurrence independent of your active layout context or established relationships.
Executes Schema Changes Dynamically: It supports structural SQL commands like ALTER TABLE, DROP INDEX, or CREATE TABLE to let you modify database architecture on the fly.
Reduces Virtual List Overhead: Complex reporting that usually requires collecting IDs via native finds can be simplified into direct, parameterized multi-table joins and data manipulation. Native ExecuteSQL vs. DoSQL Plugin
The following overview highlights the differences between leveraging standard FileMaker behavior versus extending capability with a tool like DoSQL: ExecuteSQL Speed Improvements – Claris Community
Leave a Reply