title: OPENJSON in compatibility level 100 SQL SERVER 2016
body: <p>I need to use the functionality of <code>OPENJSON()</code> in an old database with compatibility level 100. The server runs SQL SERVER 2016. So i came up with this idea: Create another DB "GeneralUTILS" (lvl 130) in the same server and call this function from lvl 100 DB:</p>
  
  <pre><code>CREATE FUNCTION [dbo].[OPENJSON_](@json NVARCHAR(MAX))
  RETURNS   @Results TABLE ([Key] nVARCHAR (4000)  , [Value] NVARCHAR(MAX), [Type] INT)
  AS
  BEGIN
      INSERT INTO @Results 
      SELECT * from OPENJSON(@json) 
  
      RETURN
  END
  </code></pre>
  
  <p><strong>But i don't have the WITH clause to modify the output table in the lvl 100 database.</strong></p>