The last powerful feature I want to address in this chapter dedicated to FireDAC is the LocalSQL functionality.
Ever wanted to load some data in a dataset (let's say you are parsing some data from a file and storing it in a memory table) and perform a SQL join statement across that standalone dataset and some data in your real database? Or, in a more modern scenario, ever wanted to collect some data from sensors and find a match against some data in your database or in some other available dataset?
In other words, some time ago, there was a neat distinction between the SQL world and other data-oriented manipulation techniques. SQL is great for set-oriented operations, joins, Cartesian products, aggregates, filtering, and similar while other data-manipulation approaches were usually heavily based on code implementations of loops, lists, and temporary data structures to collect data. Now you can easily mix the two worlds!
LocalSQL is functionality built...