This is something I'm very curious about! There's a strong meme that SQL is dynamically typed, but it is very much static. ("Compile time" is "prepare time", so it feels dynamic compared to host program compilation, but the vast majority of problems are caught before query execution, and with widespread, better tooling, could be caught at host program compile time too.)

Do you call it dynamic because of the delay in getting error feedback, because the RDBMS you use is genuinely loosey-goosey with types, or for another reason?