Calendar table sql script Firebird 3

[Gandimann]

Mein Ziel ist so eine Tabelle mit script generieren und mit entsprechende Daten zu befüllen:
Z.B : Ab 01.01.2020 bis 31.12.2050 ( es ist klar es gibt auch bewegliche Feiertage die werde ich anders regeln)

/

SQL-Code:

/ If not exists then create it



CREATE TABLE Dates_ready
(
  DateKey             BIGINT         NOT NULL PRIMARY KEY,
  [Date]              DATE        NOT NULL,
  [Day]               INT     NOT NULL,
  DaySuffix           VARCHAR(3)  NOT NULL,
  [Weekday]           INT         NOT NULL,
  WeekDayName         VARCHAR(10) NOT NULL,
  IsWeekend           INT         NOT NULL,
  IsHoliday           INT         NOT NULL,
  HolidayText         VARCHAR(64) NOT NULL,
  DOWInMonth          INT         NOT NULL,
  [DayOfYear]         INT         NOT NULL,
  WeekOfMonth         INT         NOT NULL,
  WeekOfYear          INT         NOT NULL,
  ISOWeekOfYear       INT         NOT NULL,
  [Month]             INT         NOT NULL,
  [MonthName]         VARCHAR(10) NOT NULL,
  [Quarter]           INT         NOT NULL,
  QuarterName         VARCHAR(6)  NOT NULL,
  [Year]              INT         NOT NULL,
  MMYYYY              VARCHAR(6)  NOT NULL,
  MonthYear           VARCHAR(7)  NOT NULL,
  FirstDayOfMonth     DATE        NOT NULL,
  LastDayOfMonth      DATE        NOT NULL,
  FirstDayOfQuarter   DATE        NOT NULL,
  LastDayOfQuarter    DATE        NOT NULL,
  FirstDayOfYear      DATE        NOT NULL,
  LastDayOfYear       DATE        NOT NULL,
  FirstDayOfNextMonth DATE        NOT NULL,
  FirstDayOfNextYear  DATE        NOT NULL
);