FileMaker 12 introduced a new calculation function called ExecuteSQL().
With this function you can execute an SQL SELECT query on data in a FileMaker Pro database, from within a calculation expression in FileMaker itself.

The benefits are enormous!

You can now write calculations that get data from of the FileMaker tables, independent on how these are organized in the FileMaker Relational Graph, to name just one of the advantages.

The FileMaker development crew at myFMbutler is very pleased with this exciting new feature, as it will fit for a lot of FileMaker development.
But does this mean everything has to stop there? Although this new function is very powerful, it has some shortcomings.

In this session we are going to discuss some of them, and present alternative ways of tapping into FileMaker's SQL engine using the DoSQL 2.0 plug-in.