These are examples of queries to fetch settings from the wp_options table.

Fetching settings permalink

Fetch the site's URL, name and description, all of them stored as a single value:

Fetch the site's sticky posts, which is stored as an array:

Fetch some custom option, stored as an object: