crash with one statement

Question

I have a 7,173,684 character sql select statement and it crashes. I have searched for an upper limit to a single sql statement in SQL Server, but I cant find that upper limit

Plan B is to chop the statements in the largest size allowed. I have 24k select statements that have union all fragments gluing them into one statement

so:

select top1 expression from table where key = 'value' union all
select top1 expression from table where key = 'value' union all
select top1 expression from table where key = 'value' union all

...

I tried SSMS UI and Azure Data Studio