You can use a web framework to display SQL data on a web page, write simple SQL queries yourself to link a website to a database or use a data visualization tool to generate charts and graphs ...

They leverage the comprehensive catalog of Go libraries that wrap APIs. But only plug-in authors need to know that. As a developer working with Steampipe you only see tables, and you only write SQL.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...