Some DBs allow it or allow it partially. It's a major constant friction factor for me to do a guess work across different database systems.