How secure is base64 encoding compared to hashing without salt?
Base64 does not provide any security at all. It is simply a defined mapping of 3x8 byte to 4x6 byte and intended for cases where the underlying layer is not 8 bit clean - like for E-Mail transport, to represent binary data in JSON, as part of a URL string etc. It is trivial and cheap to get the original data back from a base64 encoded string - that's the very purpose of base64.
Hashing (even without salt) is instead a one-way operation, i.e. it is not possible to directly get the original data back. It can only be done with brute-force or by using a previously created dictionary of mappings between original value and hashed value (like hashing of common passwords).
I'm wondering if it has ever been used widely in securing applications (SQL, etc.) instead of hashing.
Base64 was only used for securing applications instead of hashing by developers which did not understand that base64 does not provide any security at all. Unfortunately, there were such cases but fortunately not widely.