As the SQL statements executed by DPM for collection of scan type details is very huge and can not fit in the rows DPM shows only part of SQL Statement.
Refer to 'Scan Type Details' screenshot
By default insight doesn't show full SQL statement. If you want to see the full statement then you need to configure the 'SQL performance statistics' as below and then check those in 'Insight' workbench.
Use SQL Performance Statistics
Once you have configured and enabled the SQL Performance Statistics scan types, you can view them in the Database & OS View SQL Performance Statistics tab.
To view the SQL Performance Statistics
Refer to screenshots attached in the document.
Make sure that you have set sql_archive as On.