[EPIC] preview issues (relating to `show`)

[dataders]

Tracking issue for bugs and papercuts related to dbt show (CLI) and the VSCE model preview feature.

Open issues

• [BUG] [LSP] Preview CTE with ephemeral model raises 'show' error #176
• [VSCE] Previewing model code should use --limit to apply limits #383
• [BUG] do not compile unnecessary code when previewing query results in VSCE #421
• [BUG] Preview Fails for Versioned Models (and lineage breaks) due to dbt show syntax #482
• [BUG] dbt show -s some_analysis does not display the result #669
• [BUG] dbt show -s some_data_test does not display the result #670
• [BUG] dbt1007 error: Only one node can be selected for show (single model preview) #840
• [BUG] [VSCE] unaliaed SQL expression containing . causes Preview CTE to return Null #1026
• [BUG] Not possible to use show command with singular data tests (discrepancy with dbt-core) #1232
• [BUG] VSCE: Incorrect LIMIT placement when previewing analyses queries #1377
• [BUG] Align dbt show with the way it works in dbt Core -- Do not wrap the query in a subquery (breaks order by) and Allow setting a negative limit to remove the limit from the query #1382