Support for psycopg Composed queries

[pcrock-thmdo]

The Scout agent breaks when it tries to instrument raw queries in Django that use psycopg2's SQL string composition. Specifically, we get a TypeError: unhashable type: 'Composed' on this line of code:

scout_apm_python/src/scout_apm/core/n_plus_one_tracker.py

Line 29 in 86d1492

item = self._map[sql]

I created a workaround that converts the query to a raw string before executing it, however it involves getting a cursor and compiling the string before doing the actual query. That's more overhead than I would prefer, so it would be really nice if Scout were able to support Composed as well.

[tim-schilling]

Hi @pcrock-thmdo, thanks for opening the issue. Can you provide me with a reproducible example? That'll make the investigation a bit easier.

[pcrock-thmdo]

Thanks for responding @tim-schilling, and sorry for the delay. Because of sickness, etc., I haven't had time to do this yet, but I'll get you an example soon.

[pcrock-thmdo]

This reproduces the issue: https://github.com/pcrock-thmdo/scout-issue-749-poc

[igorkramaric]

@tim-schilling is there a plan to address this issue? We encountered the same problem recently and found a temporary workaround by avoiding SQL strings composition. It doesn't seem sustainable in the long run

[tim-schilling]

@igorkramaric I'm no longer an active maintainer for the project.