Since SQL is a scripting language, you can get away with some shortcuts that you could not do in a programming Language

One example of this is Implicit Conversions: Conversions made when your code reads “Take this object (which happens to be a number) and place it inside this other object (Which happens to be a string)”

While implicit coding may be convenient it can lead to debugging problems downstream

When you use implicit conversions any subsequent developer does not know if the conversion was intentional or if it was an accident not caught by the previous developer

Trusting Any Programming Language To Do The Right Thing