You asked

how does the psalmist's longing for god's law (e.g., psalm 119) contrast with paul's view of law increasing trespass?

Reading with you…