(postgre)sql has lots of quirky stuff that kinda qualifies. For example substring ( string text [ FROM start integer ] [ FOR count integer ] ) → text at

(postgre)sql has lots of quirky stuff that kinda qualifies. For example substring ( string text [ FROM start integer ] [ FOR count integer ] ) → text at a glance you might think that as just a normal function call, but the arguments do not follow the regular function call argument syntax, instead it has this special sauce ternary syntax.