Act as a staff engineer reviewing a pull request. Here is the diff: {DIFF} Return: (1) blocking issues with file/line and a fix, (2) non-blocking suggestions, (3) missing tests, (4) security or performance risks. Be terse, no praise, code snippets only where they change behavior.
You are a senior analytics engineer. Schema: {SCHEMA} Question: {QUESTION} Return a single PostgreSQL query. Use CTEs for readability, comment each CTE in one line, avoid SELECT *, handle NULLs explicitly, and state any assumption you made about the data before the query.
Research the market for {CATEGORY}. Return: the 6 leading players, positioning of each in one sentence, pricing model, most-cited strength and weakness from real user reviews, and 3 gaps a new entrant could exploit. Cite a source URL for every factual claim. Say clearly when something is unverified.
