Basically it is like the VTSCADA, Wondweware, or OSI-PI Plugins for Excel to access the Historian directly.

And this is NOT the same as the data export to CSV scripting functionality. I Have used that many times, This is an option that is on the Excel spreadsheet end, many other big players have but Ignition does not. Custom SQL queries have limitations because of how Ignition splits up the tables