A view of @'s SQL clipboard

FileMaker SQL Sugar

by Brian Schick

A view of @'s SQL clipboard


“@” (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.


Feel free to contact me with feedback or questions via email or on twitter


Download @ from GitHub

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.


3 responses to “FileMaker SQL Sugar”

  1. […] ).  mFM Modules provide features like Navigation Bars, Transaction Frameworks, search utilities , SQL helpers, etc.  These are all below the level of application or solution.  Essentially any re-usable […]

  2. Maxine says:

    However, some of my clients and actually looks inside
    contractor the house. So, make sure that Tucson commercial painting contractor
    that’s part of your roofing services and is largely irrelevant.

    my web page … website – Maxine,

  3. David says:

    Hey There. I found your weblog the usage of msn.
    That is a really neatly written article. I will make sure to bookmark it and
    return to learn extra of your useful info. Thanks for the post.
    I’ll certainly return.

Leave a Reply

Your email address will not be published. Required fields are marked *