SELECT * c.id, -- select all chats (c.id, c.name) for all users by name ($1) where text > 'abc'

Your SQL query contains several errors and incomplete parts. If the task is to select all chats (id, name) for all users with a given name ($1), and filter by the condition text > 'abc', a correct example query might look like this:

SELECT c.id, c.name
FROM chats c
JOIN users u ON c.user_id = u.id
WHERE u.name = $1
  AND c.text > 'abc';

Here:

• c is an alias for the chats table.
• u is an alias for the users table.
• It is assumed that the chat has a text field and a relation to the user via user_id.
• $1 is a parameter that is substituted during query execution.

If you need to select all chats for all users with a specific name, it is important to correctly use JOIN and conditions in WHERE. Also, text > 'abc' is a lexicographical string comparison, make sure this is exactly what you need.