Second this - building even a simple engine gives real insight into query planning and execution. Once parsing is handled, the core ideas are a lot more approachable than they seem.

i’ve used both a bit. cursor has more features and feels more polished, but windsurf is faster and cheaper. windsurf also has a cleaner UI. if you don’t need all the extra stuff in cursor, windsurf’s a pretty solid option.