The beauty of views is that you can do everything you would with a SQL query without writing a single line of code! And yes it does paging for you.
I know exactly where you are coming from. I'm a developer myself and my first 'itch' is to hack some code to do what I want to do. But with Drupal I feel that there has been alot of thought put into the existing major modules (CCK, Views, Panels, etc.) that everything that I would be coding would duplicate this functionality and not be as rigorously tested as these modules are.
I really suggest you take the time to learn to do things with these major modules first before you write a single line of code!
Also from a marketing perspective your website will be successful for the CONTENT you provide so you probably want to spend as much time as you can on that instead of writing code which no visitor will ever see (or apreciate).
Just my 5 cents