Where can I make complex queries for airplane tickets?

I am an experienced programmer. I would like to make complex searches such as "Travel from Stockholm to Vancouver between February 14th and 19th and back between March 12th and 18th. I want to avoid any flight-exchanges on the American continent."

I have been using Kayak, and I like their ability to pick multiple dates and the presentation is nice. However, I would like to be able to set the dates more freely and exclude transfers. I do like it to be easy to use but I am tech-savvy.

air-travel flight-search-engines

Pictures about "Where can I make complex queries for airplane tickets?"

Where can I make complex queries for airplane tickets? - Black and White Electronic Devices

Where can I make complex queries for airplane tickets? - Military airplane flying above modern skyscrapers in city

Where can I make complex queries for airplane tickets? - Person Driving A Person Flying an Aircraft

What are the three major airline ticketing systems?

Its key components are a central or airline reservation system (CRS), an inventory control system (ICS), and a departure control system (DCS.)

Which site is best for booking flight tickets?

The 12 Best Websites for Booking Flights at the Cheapest Prices [...

Book Direct Through the Airline's Website.
Momondo.
Kayak.
Expedia.
Priceline.
Orbitz.
Agoda.
Hotwire.

What questions should you ask when buying airplane tickets?

Here are seven questions you should always ask yourself before booking any flight, regardless of where you find yourself in the world.

Is the flight refundable? ...
Will you earn frequent flyer miles? ...
Is baggage included? ...
How much legroom do you get? ...
What happens if you're delayed? ...
What airports are you flying to/from?

How do I make an airline claim?

If you believe you have the right to claim compensation or reimbursement, you should contact your airline or airport directly. Compensation is not automatic, and you will need to contact your airline to make a claim. Many airlines and airports will have a claims procedure for you to follow.

SQL queries, Multiple Join,As clause, Aggregate Functions in Flight Reservation/ Booking System DBMS

Sources: Stack Exchange - This article follows the attribution requirements of Stack Exchange and is licensed under CC BY-SA 3.0.

Images: capt.sopon, capt.sopon, Harrison Haines, Rhys Abel