Insert all dates between a start and end date input

Hi All,

I’m trying to figure out some queries i need to write to insert some data into my database.

What is the best way to go about inserting a row for each date between a user defined start and end date (based on a submitting a form)?

I’m getting better with Wappler and SQL, but have yet to really use any of the WHILE or even REPEAT functions (apart from creating a nested table as per the documents)

End result would like basically like this (minus other info not relevant)

Help in the right direction would be appreciated.