I’m a consultant, so I see quite a lot of organisation’s “production code”. The quality they have in common is that it’s code that’s in production. That’s pretty much it.
But SQL doesn’t really have that concept.
Rob hits on the fundamental subjectivity of the concept and it’s worth a read.