ChatGPT to the rescue!

On a serious note, I applause your attempt at parsing calendars strictly with SQL. Years ago I tried it, gave up and just wrote a parser in PHP. Works like a charm in https://scheduletracker.app that I created for XER parsing and schedule analysis.