Hmmm, seems like the tail wagging the dog to me. All of what you say works as explained but you haven't really integrated it with SQL Server have you. If...

Good article, thank you...

Note: In the one example you're missing the column name;

DECLARE @InputQuery NVARCHAR(2000) = N'
SELECT n, o 
FROM (values (1,10), (2,20), (3,30)) a(n, o)
'
EXEC sp_execute_external_script...