No, the issue is not conflicting SQL. An ORM solves that problem extremely easily.

It's the fact that query planners and performance optimizations implemented by each database are different, and thus directly porting your current schema and queries doesn't work.