The system provides schema introspection, automatic relation detection, query composition through UI selection (tables, columns, joins, aggregates, filters), and deterministic SQL generation. Results are rendered in real time and can be exported to branded PDF reports with metadata, date ranges, and aggregation summaries.