TL;DR: there are good arguments for leading commas, but I recommend using trailing commas for consistency.
We didn't take an opinionated stance on comma placement when writing Mozilla's SQL Style Guide probably to avoid a quagmire. I'm trying to figure out where I stand now, so I wrote it …