Postgres is cursed for only allowing 65535 parameters in a single query?

Someone correct me if I am wrong, but that is a fairly large number (I think Microsoft SQL is limited to 2000 or something like that) AND this seems like a terrible design pattern.

I’d say running up against a 16bit number for a database import in 2025 is a little cursed. MS is special, still has a 260 path character limit (albiet soft now) in Windows.

Also with more phones taking an image and a video that is only 32767 snaps, which is probably a regular headache for initial imports.