One of the best (and unnoticed) improvments in server side scripting happened in FMS 15 when Execute SQL script step became server compatible. One can now use it without installing a DSN on each client. Still, it’s odd that the only way to get values from a sql source (apart from ESS of course) is to import records.
What if Execute SQL could select and return its result to a target (field or variable)? I think it would make integration with other databases more seamless.