Implicit LIMIT on queries

[joacoc]

2. would be good to have an implicit limit on query results, maybe at 100 rows or so

[bobbyiliev]

@joacoc Is your idea here to modify the actual SQL command before sending it to be executed? Or to just limit the results that are displayed? I could give this a go!

[joacoc]

@bobbyiliev I'm unsure about what is the best solution here. We should research the most spread/common practice here. We have to options:

1. Using the LSP to detect if there is a LIMIT. If there is none, add one.
2. Using the LSP to detect if the SQL is a SELECT statement. If positive, use a cursor.

The LSP part is not yet implemented. It is a command method call. It would be like sending the SQL over the wire and the LSP answers back with the structure or a yes/no.