FileMaker SQL @

View the Project on GitHub brian-schick/FileMakerSqlSugar

Welcome to @ :: FileMaker SQL Sugar


"@" is a fluid and nimble SQL power tool designed expressly for FileMaker developers.

Bringing a fresh perspective to FileMaker SQL ("FQL"), @ offers a deep set of tools to help ensure that code written is unbreakable and well structured in any manner a FileMaker developer chooses.

Drawing on tools like Markdown, jQuery, and CoffeeScript, @ offers a nimble, chainable SQL syntax that eliminates the clutter currently associated with FQL. And @ outputs fully formatted, ANSI-compliant queries, making it possible to test and share FQL queries directly in standard internet SQL tools.

@ is designed to sweeten the task of hand coding FQL. It makes it easy to build code that's exceptionally clear, and that can support complexity without becoming unreadable.

Installing @

@ is designed as a highly modular set of custom functions. It is completely self-contained, with no hooks or requirements other than the basic FileMaker 12 environment.Because of this, you can choose to simply grab the custom functions, pop them directly into any FileMaker 12 solutions, and get to work.

But there's a better way.

@ is fully integrated into the new Modular FileMaker project, and the sample "@ First" demo file contains a simple set of script wrappers that include documentation and installation tests you can use to ensure your @ installation is complete.

With this in mind, recommended installation of @ is to:

1) install the custom functions 2) install the Modular FileMaker scripts 3) run the "Test @ Installation" script to confirm that your installation is complete.

Getting Started

At is a lightweight power tool. Once you get used to it, you'll likely find it light, fast, and easy to read and write. But like any power tool, it takes a bit of time and practice to master.

The best way to start is by launching the "@ First" demo file. This file contains a quick introduction to the kinds of FQL problems @ is built to solve, and a SQL workbook that lets you create and see live results of simple and more complex queries. This is a great way to get a quick overview of @.

Next, we recommend you read through @'s inline help. Either in the demo file, or anywhere in your solutions, you can call the @ custom function itself to get detailed help on @'s capabilities and the FQL SQL dialect. To bet started, simply call @ in an environment like the Data Viewer using the syntax @("" ; "?" ). @ will give you a quick overview of its help syntax and capabilities, and give you the instructions you'll need to start digging in.

Questions? Feedback?

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