SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Trees
(
    [Id] INT,
    [Type] NVARCHAR(100),
    [Height] DECIMAL(2,1)
);
CREATE TABLE TreesGrowthLog
(
    [Day] DATETIME,
    [TreesGrowth] NVARCHAR(MAX)
);
INSERT INTO Trees ([Id], [Type], [Height])
VALUES 
 (1, 'Palm', 5.5), 
 (2, 'Pine', 6.2), 
 (3, 'Apple', 2.5), 
 (4, 'Japanese Cedar', 0.5), 
 (5, 'Spanish Fir', 0.6);
5 rows affected

SELECT * FROM (
SELECT
  highTrees = JSON_QUERY(
                (
                  SELECT 
                  Id as id,
                  Type as type,
                  Height as height
                  FROM Trees WHERE [Height] > 5
                  FOR JSON PATH
                )
              ),

  lowTrees  = JSON_QUERY(
                (
                  SELECT 
                  Id as id,
                  Type as type,
                  Height as height
                  FROM Trees WHERE [Height] < 1
                  FOR JSON PATH
                )
              )
FOR JSON
  PATH, WITHOUT_ARRAY_WRAPPER
) TreesJson;
Msg 8155 Level 16 State 2 Line 26
No column name was specified for column 1 of 'TreesJson'.

INSERT INTO TreesGrowthLog ([Day],[TreesGrowth])
    VALUES (CAST(GETDATE() AS Date), (SELECT * FROM TreesJson FOR JSON AUTO))
Msg 208 Level 16 State 1 Line 1
Invalid object name 'TreesJson'.