FileMaker SQL Sugarby Brian Schick
“@” (FileMaker SQL Sugar) is a power tool that sweetens the task of writing clean, readable, well-structured FileMaker SQL
- Makes it much easier to write powerful, unbreakable FileMaker SQL
- Helps developers think and code directly in native SQL
- Easily handles advanced SQL functions directly inline using an extensible, chainable syntax
- Outputs ANSI-standard queries that can be shared / tested with internet SQL tools
None. @ is implemented as a lightweight set of namespaced custom functions, with no outside dependencies.
@ is free and open source, under the terms of the MIT Open Source License.
@ comes with a demo file — a quick introduction to @’s purpose and philosophy, and an interactive SQL workbook that lets you view, modify, and test live @ queries. This is an ideal place to start.
In daily use, @ itself can be queried directly to get help directly within any solution where it’s installed. You can access @’s inline help in a Data Viewer or any context where a function can be evaluated, using the syntax @(“” ; “?” ). This will display a quick overview of @’s help syntax and options, and explain how to get detailed help on desired topics.
Note: In the following window, you can either click the “download as zip” button to grab all files, or choose “View the Project on GitHub” for more granular options.