@@ -419,6 +419,7 @@ func (m Model) helpView() string {
419419 header := lipgloss .NewStyle ().Foreground (lipgloss .Color ("205" )).Bold (true )
420420 key := lipgloss .NewStyle ().Foreground (lipgloss .Color ("229" )).Width (15 )
421421 desc := lipgloss .NewStyle ().Foreground (lipgloss .Color ("241" ))
422+ tutorial := lipgloss .NewStyle ().Foreground (lipgloss .Color ("86" ))
422423
423424 lines := []string {
424425 header .Render ("Navigation" ),
@@ -436,6 +437,19 @@ func (m Model) helpView() string {
436437 key .Render ("v" ) + desc .Render ("Toggle Detail View for selected row" ),
437438 key .Render ("c" ) + desc .Render ("Copy entire result set as CSV to clipboard" ),
438439 "" ,
440+ header .Render ("SQL Quick Tutorial" ),
441+ tutorial .Render (" -- Select all columns from a table" ),
442+ tutorial .Render (" SELECT * FROM table_name;" ),
443+ tutorial .Render (" -- Filter results" ),
444+ tutorial .Render (" SELECT * FROM users WHERE age > 18;" ),
445+ tutorial .Render (" -- Join tables" ),
446+ tutorial .Render (" SELECT u.name, p.title FROM users u JOIN posts p ON u.id = p.user_id;" ),
447+ tutorial .Render (" -- SQLite Meta: List Tables / Schema" ),
448+ tutorial .Render (" SELECT name FROM sqlite_master WHERE type='table';" ),
449+ tutorial .Render (" PRAGMA table_info(table_name); -- Describe table" ),
450+ tutorial .Render (" -- Postgres Meta: List Tables" ),
451+ tutorial .Render (" SELECT table_name FROM information_schema.tables;" ),
452+ "" ,
439453 header .Render ("General" ),
440454 key .Render ("h" ) + desc .Render ("Toggle this help screen" ),
441455 key .Render ("Esc" ) + desc .Render ("Clear input or return from detail/help" ),
0 commit comments