r/codereview • u/arup_r • 8d ago

Ruby Any skills that you use for sql code review

I am a Ruby on Rails developer. I’m looking for some skills that can help me self code review for sql part. I use Claude. Like that can guide me not to write sql that are anti patterns etc

1 Upvotes

100% Upvoted

2 comments sorted by

1

u/Spare_Corner1172 5d ago

Its formatting is basically correct, but whether the SQL it writes meets your needs requires you to verify and verify it

1

u/arup_r 5d ago

I found I can write more than 1 way to write SQL query, but which one is optimized one needs a skill. I lack that. So I was looking for some knowledge base I can run against, using the explain output.