One of the new language features added in SQL Server 2022 is the GENERATE_SERIES function. This allows you to generate a
SELECT * FROM GENERATE_SERIES(start=1, stop=7)
This gives me a simple sequence of numbers in a result set, with the column header, value.